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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet opens to new line
Private Sub Workbook_Open()
Cells(Cells(Rows.Count, "B").End(xlUp).Row + 1, 2).Select End Sub or better IMO Private Sub Workbook_Open() Cells(Rows.Count, "B").End(xlUp).Offset(1,0).Select End Sub -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Diane" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet opens to new line
I would try inserting a new column A, to the left of your numbered column and
narrowing it to only 1 character wide if desired......... Vaya con Dios, Chuck, CABGx3 "Diane" wrote: 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. |
Reply |
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 |