View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
John Bundy John Bundy is offline
external usenet poster
 
Posts: 93
Default opening sheet, next available cell displayed

Put this on a workbook open event, change sheet name and cell column as
needed
Private Sub Workbook_Open()
Sheets("sheet1").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Select
End Sub

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Stephen" wrote in message
...
When I open a workbook/sheet, I want the next available cell for data
entry
to be displayed, at the moment the page scrolls somewhere halfway up
existing
data, meaning I have to scroll down to the next data entry point. Can I
do
this ??