How do I show Row and Column where I want them
 

Hi everybody,
I there a way to make a specific Row The top-most row on
the screen, and a specific column the left-most column on
the screen?

Thanks

How do I show Row and Column where I want them
 

Yes, scroll around until you get the required cell in the top left of the
Excel window, then do a WindowFreeze Panes

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Chris W" wrote in message
...
Hi everybody,
I there a way to make a specific Row The top-most row on
the screen, and a specific column the left-most column on
the screen?

Thanks

How do I show Row and Column where I want them
 

If it is dynamic, then perhaps this:

ActiveWindow.ScrollRow = 10
ActiveWindow.ScrollColumn = 15

--
Regards,
Tom Ogilvy


"Chris W" wrote in message
...
Hi everybody,
I there a way to make a specific Row The top-most row on
the screen, and a specific column the left-most column on
the screen?

Thanks