Range Names Help

  • Thread starter Thread starter Lanmeister
  • Start date Start date
L

Lanmeister

Hey people.

How do I get the top left cell of a range name to be the top left cell of
the screen using the GOTO function? I guess it will be done via VBA tacked
on to the end of the macro, but I can't figure it out.

All help appreciated. Keep up the great work in these NGs as your assistance
is always appreciated

TIA

Lanmeister
 
Application.Goto Range("test"), scroll:=True
Hey people.

How do I get the top left cell of a range name to be the top left cell of
the screen using the GOTO function? I guess it will be done via VBA tacked
on to the end of the macro, but I can't figure it out.

All help appreciated. Keep up the great work in these NGs as your assistance
is always appreciated

TIA

Lanmeister
Click to expand...
 
If you superimpose a dummy RangeName over your Range that is larger than
your screensize in columns and rows but has the same upper left cell as your
original Range, then if you F5 to the dummy RangeName it will automatically
put your Ranges upper left cell in the upper left of your
screen.............."whew"

Vaya con Dios,
Chuck, CABGx3
 
Gracias Chuck. It all works well
CLR said:
If you superimpose a dummy RangeName over your Range that is larger than
your screensize in columns and rows but has the same upper left cell as your
original Range, then if you F5 to the dummy RangeName it will automatically
put your Ranges upper left cell in the upper left of your
screen.............."whew"

Vaya con Dios,
Chuck, CABGx3
Click to expand...
 
Back
Top