Use of Immediate Window

J

JMay

How can I (from within my immediate window) change the activecell from say
B7
to C10?
 
B

Bob Phillips

Range("C10").Select

If you are debugging code, you can even stop the execution with break, and
set variables in the immediate window. Just don't use the print qualifier
when you do.
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
J

JMay

Thanks to both you.

Bob Phillips said:
Range("C10").Select

If you are debugging code, you can even stop the execution with break, and
set variables in the immediate window. Just don't use the print qualifier
when you do.
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top