Worksheet opens to new line
When A was a blank column, I would open the worksheet and it would go to the
next available line automatiacally. This was working well with the following:
Private Sub Workbook_Open()
Cells(Cells(Rows.Count, "A").End(xlUp).Row + 1, 1).Select
End Sub
but now I inserted automatic numbering in column A. I tried to substitute
"A" (in the above formula) with "B", which is now the new point of entry when
I open the worksheet, but it does not work.
Can anyone please help? Thanks.
|