Posted to microsoft.public.excel.programming

lvcha.gouqizi lvcha.gouqizi is offline

external usenet poster

Posts: 38

what's the difference between Activate and Select for Worksheet?

Hi,

As I know that after

worksheets("****").Select, then we can use
ActiveSheet.**** to do anything.

But how about the Activate method? Can we use

Worksheets("****").Activate
ActiveSheet.****

in the way?

thanks.

Reply With Quote

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
Smart use of .Activate; .Select; .Copy with Sheets(1) va Worksheet	Dennis	Excel Discussion (Misc queries)	5	July 24th 05 01:05 AM
Difference between Select and Activate	Darlajane[_2_]	Excel Programming	2	November 12th 04 04:07 PM
select vs activate	Chip Pearson	Excel Programming	0	September 9th 04 04:02 PM
Difference between .Activate and .Select	JMMach, MCSC	Excel Programming	3	August 24th 04 05:47 PM
Any difference between Sheets Activate and Select?	Don Wiss	Excel Programming	1	October 28th 03 12:46 AM

All times are GMT +1. The time now is 08:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us