activate

  • Thread starter Thread starter ranswert
  • Start date Start date
R

ranswert

What is the difference between Range().activate and Range().select?
Thanks
 
If you have a single cell selected then nothing. But if you have a range of
cells selected (e.g. en entire column) then Range(actcell).activate leaves
your selected range unchanged and activates actcell within that range, while
Range(actcell).select clears the old selection and actcell shall be your new
selection.

Regards,
Stefi


„ranswert†ezt írta:
 
Try this:

with activesheet
.range("a1:e12").select
.range("c7").activate
end with
 
Thanks for the info

Stefi said:
If you have a single cell selected then nothing. But if you have a range of
cells selected (e.g. en entire column) then Range(actcell).activate leaves
your selected range unchanged and activates actcell within that range, while
Range(actcell).select clears the old selection and actcell shall be your new
selection.

Regards,
Stefi


„ranswert†ezt írta:
Click to expand...
 
You are welcome! Thanks for the feedback!
Stefi

„ranswert†ezt írta:
 
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

Run macro from active workbook whose name keeps changing 20
conso macro 0
Paste a range and shifting away existing data 1
Clearing an Active X text box with a macro 3
File Name changes with dates and Deleting Rows of Zeros 0
Copy Data from Closed File to Existing File 0
clear all sheets code 4
Loop to End 0

Back
Top