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

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