| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
make exel open at the bottom of the worksheet
I have a problem. Every time I open a worksheet excel it starts me off at
A86. I need to know how I can make it open and start me off in the first empty colum |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
make exel open at the bottom of the worksheet
Assuming you want to search row 1, right click sheet tabview
codecopy/paste thisSAVE now each time you activate the sheet it will open at the next empty column in row 1 Private Sub Worksheet_Activate() Cells(1, columns.Count).End(xlToLeft).Offset(, 1).Select End Sub -- Don Guillett SalesAid Software "Roger S" <Roger wrote in message ... I have a problem. Every time I open a worksheet excel it starts me off at A86. I need to know how I can make it open and start me off in the first empty colum |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| mail merging 2 workbooks??? | Excel Discussion (Misc queries) | |||
| When I open a an existing excel worksheet, it duplicates itself a. | Excel Discussion (Misc queries) | |||
| Always open a worksheet at A1 | Excel Discussion (Misc queries) | |||
| Open workbook to specific worksheet | Excel Discussion (Misc queries) | |||
| Is there a way to make Excel 2000 open a new worksheet in a new w. | Excel Discussion (Misc queries) | |||
Linear Mode
