View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Diane
 
Posts: n/a
Default 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.