Posted to microsoft.public.excel.programming

StephanieH StephanieH is offline

external usenet poster

Posts: 95

ActiveWorkbook.Sheets.Select

I'm trying to select all sheets in my workbook. In the past, I've always
used ActiveWorkbook.Sheets.Select. For some reason, this time I'm getting
"Run-time error '1004'". I've never seen this in the past.

Any other ways to select all sheets? Anyone have an idea why it would work
in other workbooks, but not this one?

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
Select the same cell in sheets 2 & sheets 3	Oggy	Excel Programming	0	January 8th 07 08:02 PM
select sheets	snax500[_2_]	Excel Programming	6	June 8th 05 04:48 AM
Adding a sheets name to the worksheets that are copied over from an addin file to the activeworkbook	KimberlyC	Excel Programming	2	May 7th 05 04:10 AM
ActiveWorkbook.Sheets.Count	yankee428	Excel Programming	5	November 10th 04 06:22 AM
select a1 on all sheets	Piers Clinton-Tarestad	Excel Programming	1	October 1st 03 08:34 PM

All times are GMT +1. The time now is 12:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us