activate
 

What is the difference between Range().activate and Range().select?
Thanks

activate
 

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:

What is the difference between Range().activate and Range().select?
Thanks

activate
 

Try this:

with activesheet
.range("a1:e12").select
.range("c7").activate
end with


ranswert wrote:

What is the difference between Range().activate and Range().select?
Thanks

--

Dave Peterson

activate
 

Thanks for the info

"Stefi" wrote:

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:

What is the difference between Range().activate and Range().select?
Thanks

activate
 

I'll give that a try
thanks

"Dave Peterson" wrote:

Try this:

with activesheet
.range("a1:e12").select
.range("c7").activate
end with


ranswert wrote:

What is the difference between Range().activate and Range().select?
Thanks

--

Dave Peterson

activate
 

You are welcome! Thanks for the feedback!
Stefi

€žranswert€� ezt Ã*rta:

Thanks for the info

"Stefi" wrote:

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:

What is the difference between Range().activate and Range().select?
Thanks