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. |
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 |
All times are GMT +1. The time now is 05:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com