Macro to Move Selected Cell to Top of Screen
 

Thanks for the excellent advice. I tried it and it worked perfectly. Th
only thing I need to figure out - which I think should be relativel
straightforward - is how to do what you've requested based on th
active cell vs. on (for eg.) B15. The reason for this is because
often add/delete entries so the letter "A" (or whatever) may ge
shifted up or down and the macro won't work.

I think there must be an "ActiveCell" function that could replace th
cell definition (eg. B15). If you happen to know what it is - great
I'll also try to fiddle around to see if I can figure it out.

Bottom line: You've showed me how to focus the defined cell to the to
of the screen which is my primary challenge. Thanks for that.

Dave :

--
sns
-----------------------------------------------------------------------
snsd's Profile: http://www.excelforum.com/member.php...fo&userid=1591
View this thread: http://www.excelforum.com/showthread.php?threadid=27390

Macro to Move Selected Cell to Top of Screen
 

No probs......

Not sure of the ActiveCell funtion bit you require.......

Others may be help with that bit.


Hope you get it sorted!


Celtic_Avenger
:cool: :cool: :cool: :cool: :cool

--
Celtic_Avenge
-----------------------------------------------------------------------
Celtic_Avenger's Profile: http://www.excelforum.com/member.php...fo&userid=1410
View this thread: http://www.excelforum.com/showthread.php?threadid=27390