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

Please Login or Register  to view this content.

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.

[Bob Phillips]

Maybe try

application.sendkeys ("+{RIGHT}")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"VBAvirgin" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[VBAvirgin]

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.