Maybe qualifying the sheets would be enough:

with workbooks("Loan Recovery 12mo Liq by CO Compiled n.xls")
.activate
.sheets.select
end with



StephanieH wrote:

I've tried listing the actual pages (no response)
Windows("Loan Recovery 12mo Liq by CO Compiled n.xls").Activate
Sheets(Array("Charts", "Rollup", "ARP", "Auto Finance", "RSB",
"Commercial", _
"Credit Card", "DDA", "Direct", "FUHEB", "HEL", "Lease", "FUMC",
"TMS - PEL", "PEL", _
"Revolving", "TMS", "DFS", "W & T")).Select

and selecting all sheets regardless of name

Windows("Loan Recovery 12mo Liq by CO Compiled n.xls").Activate
Sheets.Select

Neither is working.

To force it to work, I've inserted a break and I'm manualy selecting all
sheets each time it stops (it's in the middle of loop).

The only other thing I can think of that might affect it is that I'm
toggling between two workbooks. The second workbook contains worksheets with
the same title except "Charts".

Could that trip it up even though the second workbook would not be active at
the time?

"Dave Peterson" wrote:

Are you sure you're looking at the correct workbook?

Sheets.select

should select all the sheets of the activeworkbook.

StephanieH wrote:

What might prevent Sheets.Select from working? I've run across the same
problem in Excel 200 and Excel 2003 in different workbooks. In each case,
the line Sheets.Select has no response (doesn't select any of the sheets in
the workbooks). There's no error so the macro continues to run.

I've also gome back and recorded an array that lists each of the sheets and
replaced the "Sheets.Select", but it does the same thing.

The odd thing is that each of these commands do work in other workbooks, so
I'm perplexed on why it works on some but not others. Anyone aware of
anything I can check?

--

Dave Peterson


--

Dave Peterson