Opening in Same Cell

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

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

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