I have a macro that inserts rows and copies formulas on two worksheets,
and then selects the first cell into which the user should begin to
enter data.

The problem is that even though the right cell is selected for the
user, that cell is not necessarily visible on screen. (The screen may
be showing rows 70 to 100, when the relevant row is actually 500.)

Is there a way to "find" the active cell? To make it so that Excel has
not only selected the active cell, but is actually showing it as well?


--
shellshock
------------------------------------------------------------------------
shellshock's Profile: http://www.excelforum.com/member.php...o&userid=24935
View this thread: http://www.excelforum.com/showthread...hreadid=391978