Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sendkeys and wait variant
I'm running a macro with a sendkeys statement, followed by a past
command. However, I can't seem to get the wait variant to work? Th paste is running before the sendkeys, and for the life of me I can' figure this one out. Here's a snipit: You can see where I've tried to run the wait seperate, but it run BEFORE the sendkeys also. Application.CutCopyMode = False Selection.Cut Range("D5").Select Application.SendKeys "{END}{DOWN}{DOWN}", True 'Application.Wait (Now + TimeValue("0:00:02")) Application.Run "PASTE" Call me stupid, but I'm stuck -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sendkeys(keys,wait) how do I use wait | Excel Discussion (Misc queries) | |||
Should I Wait? | Excel Discussion (Misc queries) | |||
VBA Code to wait 50-150 mS | Excel Programming | |||
wait | Excel Programming | |||
Problem with WAIT | Excel Programming |