Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select OR Activate ? Which when and Why?
Select OR Activate ? Which when and Why?
i have never been able to work out when i should select and when i should activate when using vba - does anyone have a good explanation? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select OR Activate ? Which when and Why?
Select can be multiple cells, but only one is active.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Buffyslay" wrote in message ups.com... Select OR Activate ? Which when and Why? i have never been able to work out when i should select and when i should activate when using vba - does anyone have a good explanation? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select OR Activate ? Which when and Why?
I suggest searching this newsgroup for "select versus activate" or
"select vs activate". Merjet |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select OR Activate ? Which when and Why?
Sub a()
Range("A1:C5").Select Range("B2").Activate End Sub -- Jim "Buffyslay" wrote in message ups.com... | Select OR Activate ? Which when and Why? | | i have never been able to work out when i should select and when i | should activate when using vba - does anyone have a good explanation? | |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select OR Activate ? Which when and Why?
Usually not necessary or desirable
range("a2:a33").copy range("b3") -- Don Guillett SalesAid Software "Buffyslay" wrote in message ups.com... Select OR Activate ? Which when and Why? i have never been able to work out when i should select and when i should activate when using vba - does anyone have a good explanation? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select OR Activate ? Which when and Why?
A Selection may contain one or more cells. Activate makes exactly one of
those cells active. E.g, Sub AA() Range("A1:A10").Select MsgBox "Note the ActiveCell: (A1)" Range("A5").Activate MsgBox "Note the ActiveCell: (A5)" End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Buffyslay" wrote in message ups.com... Select OR Activate ? Which when and Why? i have never been able to work out when i should select and when i should activate when using vba - does anyone have a good explanation? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
.Activate vs. .Select in VBA | Excel Discussion (Misc queries) | |||
select vs. activate | Excel Programming | |||
select vs activate | Excel Programming | |||
select vs activate | Excel Programming | |||
Difference between .Activate and .Select | Excel Programming |