Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening in Same Cell
How do I make my worksheet open in the next row available? I have a 3000+
row file and every time I open it, it reverts to row 2926. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening in Same Cell
Without any macro help, the workbook should open in the same location that it
was last saved. But with macro help, you can make it do what you want: Option Explicit sub Auto_Open() dim NextCell as range with worksheets("sheet99") set nextcell = .cells(.rows.count,"A").end(xlup).offset(1,0) end with application.goto nextcell, scroll:=true end sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm I used sheet99 and the bottom of column A. Change these to what you want. carrietimeless wrote: How do I make my worksheet open in the next row available? I have a 3000+ row file and every time I open it, it reverts to row 2926. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Active Cell when opening workbook | Excel Worksheet Functions | |||
Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
How to Copy the value of a cell to any given cell | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |