View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PapaBear PapaBear is offline
external usenet poster
 
Posts: 5
Default Worksheet(s) open to last used row

Greetings, I have a workbook with 50+ worksheets in it. Each day when I
launch my workbook I have to scroll down to the last few visible rows to be
able to enter in the new data for the day. Every time, 50 times... It's
getting a little tedious. Is there a way to code the worksheet/workbook so
that the worksheet opens up so that the last two or three filled rows are
visible at the top of the worksheet?

(I keep thinking, "If it default opens to the first row, surely there is a
way to get it to default open to the "x" row...")
Thanks,