Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
SendKeys syntax problem
Can anyone please help. I am performing a search, that part of the code is working fine. When my result cell is activated, I would like to select both it, and the cell to the immediate right of it. I've tried using SendKeys, but I'm having difficulties with the syntax obviously. Code: -------------------- Application.SendKeys +("{RIGHT}") -------------------- I'm using the "plus"sign "+" for the SHIFT key to hold and select, but I'm obviously writing the {RIGHT} portion of the code incorrectly, as I get a run time error. Any assitance would be much appreciated. This is driving me nuts. Thanx in Advance. -- VBAvirgin ------------------------------------------------------------------------ VBAvirgin's Profile: http://www.excelforum.com/member.php...o&userid=16327 View this thread: http://www.excelforum.com/showthread...hreadid=497814 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
SendKeys syntax problem
Maybe try
application.sendkeys ("+{RIGHT}") -- HTH Bob Phillips (remove nothere from email address if mailing direct) "VBAvirgin" wrote in message ... Can anyone please help. I am performing a search, that part of the code is working fine. When my result cell is activated, I would like to select both it, and the cell to the immediate right of it. I've tried using SendKeys, but I'm having difficulties with the syntax obviously. Code: -------------------- Application.SendKeys +("{RIGHT}") -------------------- I'm using the "plus"sign "+" for the SHIFT key to hold and select, but I'm obviously writing the {RIGHT} portion of the code incorrectly, as I get a run time error. Any assitance would be much appreciated. This is driving me nuts. Thanx in Advance. -- VBAvirgin ------------------------------------------------------------------------ VBAvirgin's Profile: http://www.excelforum.com/member.php...o&userid=16327 View this thread: http://www.excelforum.com/showthread...hreadid=497814 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
SendKeys syntax problem
Thank You Bob for your quick & helpful response. I knew it was just a what goes where thing that was bogging me down. Thanx again my friend.:) -- VBAvirgin ------------------------------------------------------------------------ VBAvirgin's Profile: http://www.excelforum.com/member.php...o&userid=16327 View this thread: http://www.excelforum.com/showthread...hreadid=497814 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Syntax problem | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
problem office assistant | Excel Discussion (Misc queries) |