Use of Immediate Window

  • Thread starter Thread starter JMay
  • Start date Start date
J

JMay

How can I (from within my immediate window) change the activecell from say
B7
to C10?
 
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)
 
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)
Click to expand...
 
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

Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Can Vba workout if a selection is part of a group? 0
Screwy lookup function 2
Excel Help to copy information from one row at a time to another sheet 1
Macro Relative Cells 3
How do I summarize total hours over multiple days 5
error with code 4

Back
Top