Cell Position

[Bill Rendon]

I am running a number of macros that select certain cells within my
spreadsheet. This selected cell is the top left corner of a data area (6
Columns x 20 Rows) My problem is that when it is selecting the cell that is
down the sheet, then the cell just stays in the bottom corner of the screen
so you can't see the data. Is there any code I can put within the macro
that will move the selected cell up-to the top left hand corner of the
screen.

Thanks in advance.

Bill................

 

[jr]

if nothing fancier comes up try moving the cursor down a
few screens and then going to the top left corner. This
wil display the data onto the screen.

 

[John Wilson]

Bill,

Try this:

Application.Goto Reference:=Range(ActiveCell.Address), Scroll:=True

John