Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
opening sheet, next available cell displayed
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 ?? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 ?? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
opening sheet, next available cell displayed
Note: If sheet1 is not the activesheet when you open the workbook the code is not working
Use this in the open event Application.Goto Sheets("Sheet1").Cells(Rows.Count, "A").End(xlUp)(2) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John Bundy" wrote in message ... 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 ?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
jump to active cell in other sheet . | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Want cell ref. to change after sort in other sheet | Excel Discussion (Misc queries) | |||
Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) |