| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert line on other worksheet depending upon result in cell? | Excel Discussion (Misc queries) | |||
| Bringing Last line of worksheet to a Summary page | Excel Worksheet Functions | |||
| Phantom Line on Worksheet | Excel Discussion (Misc queries) | |||
| advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
| Trying to freeze panes. line down and through middle of worksheet. | Excel Worksheet Functions | |||
Threaded Mode
