View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How do I simulate a cursor down in Excel Macros

I was interpreting the cursordown as end, then down arrow, but I see your
point - he probably wants just a down arrow. I think he would need sendkeys
for that.

or something like

set rng = ActiveCell.offset(1).Resize(1000).SpecialCells(xlV isible)
rng(1).Select

The 1000 being somewhat arbitrary

--
Regards,
Tom Ogilvy


"Nigel" wrote in message
...
Tom,

Does not that take you to the last row in the region ? The OP wanted the
cell of the next un-hidden row.

--
Cheers
Nigel



"Tom Ogilvy" wrote in message
...
ActiveCell.End(xldown)

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
Yeah, I thought about putting it in a loop and checking the hidden
property but I thought, surely, there must be a CursorDown function
that would achieve the same thing and do all necessary checking for
more rows etc. etc.

Does anyone know if there is, or does anyone know if there definately
isn't!

Thanks for the replies.

Steve