ActiveCell.End(xlDown/XlUp/xlToRight/xlToLeft).Select



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"cooldyood" wrote
in message ...

hi all,

I keep hitting this problem and I'm sure there's a way to resolve
this.

When recording macros, I always use the Ctrl+arrow combinations to
navigate across cells. But when I look at the code, there are always
hardcoded cell numbers. Is there a list of functions I can use for
Ctrl+arrow (or just the arrow) programatically?

Thanks a lot!


--
cooldyood
------------------------------------------------------------------------
cooldyood's Profile:
http://www.excelforum.com/member.php...o&userid=35611
View this thread: http://www.excelforum.com/showthread...hreadid=559466