Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate vs Select a sheet
Hello all,
What is the difference between these two: Sheets("Sheet1").Activate Sheets("Sheet1").Select Thanks, John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate vs Select a sheet
You can select more than one, but only one can be active.
"John Broderick" wrote: Hello all, What is the difference between these two: Sheets("Sheet1").Activate Sheets("Sheet1").Select Thanks, John |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate vs Select a sheet
Ok, I understand that I can click on a sheet tab with the mouse to activate
it. Then if I Ctrl-click I can select additional sheets. Howver letws say we are dealing with just 2 hseets in the workbook. If Sheet2 is active then the command Sheets("Sheet1").Activate is the same as clicking on the Sheet1 tab with the mouse. Does the command Sheets("Sheet1").Select do exactly the same thing? "JLGWhiz" wrote in message ... You can select more than one, but only one can be active. "John Broderick" wrote: Hello all, What is the difference between these two: Sheets("Sheet1").Activate Sheets("Sheet1").Select Thanks, John |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate vs Select a sheet
Hello John,
Yes, if you only have 2 sheets, it is no difference. Sheets("Sheet1").Activate is the same as clicking on the Sheet1 tab with the mouse. What's your problem you are facing? Sincerely, Wei Lu Microsoft Online Community Support ================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate vs Select a sheet
Hi Wei
I am reading through someone else's code, and they seem to use Sheets("Sheet1").Select where I would have used Sheets("Sheet1").Activate. I think I understand the difference between Activate and Select as applied to cell ranges, but I was not too sure when applied to sheets. It was unfamiliar to me and I just wanted to make sure I wasn't missing somthing. John "Wei Lu [MSFT]" wrote in message ... Hello John, Yes, if you only have 2 sheets, it is no difference. Sheets("Sheet1").Activate is the same as clicking on the Sheet1 tab with the mouse. What's your problem you are facing? Sincerely, Wei Lu Microsoft Online Community Support ================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights. |
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 a sheet and activate a Window | Excel Programming | |||
select vs activate | Excel Programming | |||
select vs activate | Excel Programming |