Sendkeys in Visual Basic

How do I place a pause using sendkeys?

My problem is this – I need to copy a frame containing data from a web page and paste it into a particular worksheet in Excel then return to the start worksheet to begin the routine again.

Sendkeys works fine up to the point of pasting, but obviously the code to return to the start sheet executes before the paste, and the table is pasted into the start sheet.

I’ve tried ‘slowing’ the routine down by adding some ‘go to’s’ and sendkeys “{TABS}” after the paste but it makes no difference – the code still executes in the wrog order.

Many thanks