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
 
Application.Goto Reference:=Worksheets("sheet2").Range("A60"), Scroll:=True
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Combine Data from Multiple Sheets with Cell References 4
How to make A1 the active cell in all visible worksheets ? 3
Copy contents of cell to another tab 2
choosing cell to top left of visible window 3
Pasting cell contents into a macro 1
DREAM FEATURE: A macro that moves a row but asks me where to move it 18
Code for multiple select of cells 16
Copy specific cells to another tab 6

Back
Top