Opening in Same Cell

C

carrietimeless

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.
 
D

Dave Peterson

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.
 
Top