How to show the active cell after running a macro?

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?

You can have it scroll to the row where the active cell is

ActiveWindow.ScrollRow = ActiveCell.Row

HTH

That's exactly what I needed!

Thanks so much; I figured there had to be a way to scroll the window but I just didn't know how to do it.