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

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

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

Application.Goto Reference:=Worksheets("sheet2").Range("A60"), Scroll:=True

--
Regards,
Tom Ogilvy

"Bob Reynolds" wrote in message
.. .
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