Making an active cell the first one to appear on the spreadsheet

  • Thread starter Thread starter Bob Reynolds
  • Start date Start date
B

Bob Reynolds

Hi, I have a workbook that I use two macros in to "go to" another sheet.
When I select macro one it takes me to the other sheet and because it starts
on A1 it's automatically in the upper left most col.
However about 60 lines down I have another set of instructions (on the same
referenced sheet) that I would like to call up and become the upper left
most cell when the macro goes to it. Right now I can get it selected by
macro but it shows up about midpoint down the page.

Any help would be appriciated.
Thanks
BOB
 
Back
Top