| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
activate
What is the difference between Range().activate and Range().select?
Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| activate VBA | Excel Programming | |||
| activate VBA | Excel Programming | |||
| activate VBA | Excel Programming | |||
| Windows().Activate vs Workbooks().Activate | Excel Programming | |||
| Workbook.Activate / Window.Activate problem | Excel Programming | |||
Linear Mode
