View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default simulate pressing CTRL and A

Try using "^A" as the argument to the SendKeys method (which is covered in
the help files for SendKeys by the way).

--
Rick (MVP - Excel)


"geebee" (noSPAMs) wrote in message
...
hi,

well this is being done while in an IE window. i used the following to
simulate hitting ENTER key:

Windows.Application.SendKeys "{ENTER}"
SendKeys "{ENTER}"

so i am afraid cells.select will not work within the IE window. is there
a
more specific sendkeys code?

thanks in advance,
geebee


"Jim Thomlinson" wrote:

Ctrl+A will select all cells so you should be able to use
cells.select
--
HTH...

Jim Thomlinson


"geebee" wrote:

hi,

how do you simulate pressing CTRL and A at the same time? would you
use the
SendKeys method? If so I am not sure of the code? If not, any ideas?

thanks in advance,
geebee