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