Posted to microsoft.public.excel.programming

John Broderick[_2_] John Broderick[_2_] is offline

external usenet poster

Posts: 8

Activate vs Select a sheet

Hello all,

What is the difference between these two:
Sheets("Sheet1").Activate
Sheets("Sheet1").Select

Thanks,
John

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
.Activate vs. .Select in VBA	Dave F	Excel Discussion (Misc queries)	1	January 24th 07 03:41 PM
select vs. activate	SP[_4_]	Excel Programming	4	June 15th 05 12:27 PM
Select a sheet and activate a Window	Hari Prasadh	Excel Programming	6	January 31st 05 10:01 AM
select vs activate	Ron de Bruin	Excel Programming	0	September 9th 04 04:05 PM
select vs activate	Chip Pearson	Excel Programming	0	September 9th 04 04:02 PM

All times are GMT +1. The time now is 03:11 PM.

About Us

"It's about Microsoft Excel"