SendKeys syntax problem

[VBAvirgin]

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, an
the cell to the immediate right of it.
I've tried using SendKeys, but I'm having difficulties with the synta
obviously.

Code
-------------------
Application.SendKeys +("{RIGHT}"
-------------------

I'm using the "plus"sign "+" for the SHIFT key to hold and select, bu
I'm obviously writing the {RIGHT} portion of the code incorrectly, as
get a run time error.
Any assitance would be much appreciated. This is driving me nuts. Than
in Advance

 

[Bob Phillips]

Maybe try

application.sendkeys ("+{RIGHT}")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[VBAvirgin]

Thank You Bob for your quick & helpful response. I knew it was just
what goes where thing that was bogging me down. Thanx again m
friend.: