Hello all,
I tried using the following VBA to have the first blank cell within the E9:E48 range be selected whenever the worksheet is activated. 

Private Sub Worksheet_Activate() 
    Range("E8").End(xlDown).Offset(1, 0).Select 
End Sub
The problem? It selects the E49 cell because the E9:E48 column cells have formulas in them. If I have a value in cell E12, for example, what VBA code will be needed to have the E13 cell be selected?

Thanks for your support or even considering the help on this issue!
JN