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

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

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