Posted to microsoft.public.excel.programming

brzak

external usenet poster

Posts: 35

identify selected worksheets

probably very simple, but I can't quite work it out.

If more than one worksheet is selected, the code for whis action would
be:

Sheets(Array("Sheet1", "Sheet2")).Select

how do i access this information. (I would like to apply changes to
Sheet1 and Sheet2, and not to Sheet3)

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
Cross reference two worksheets to identify matches	Christie	Excel Worksheet Functions	4	January 14th 09 08:38 PM
Identify selected chart	Michael Singmin	Excel Programming	3	March 14th 05 10:59 AM
Need to identify object selected.	Neil Bhandar[_2_]	Excel Programming	3	January 17th 04 06:50 AM
Identify User Selected Range	RonF	Excel Programming	3	January 12th 04 04:36 PM
Identify Range Selected By User	RonF	Excel Programming	1	January 9th 04 05:29 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us