using object range to call up worksheets
 

Why won't this work?

For Each a In DataSheet
a.Select
--
Nicole
BI Programmer/Analyst
Consultant

using object range to call up worksheets
 

As what data types are 'a' and 'DataSheet' declared?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Nicole" wrote in message
...
Why won't this work?

For Each a In DataSheet
a.Select
--
Nicole
BI Programmer/Analyst
Consultant

using object range to call up worksheets
 

What is DataSheet? If yo want to loop through the worksheets then something
like this perhaps

dim a as Worksheet

for each a in Worksheets
a.Select
next a
--
HTH...

Jim Thomlinson


"Nicole" wrote:

Why won't this work?

For Each a In DataSheet
a.Select
--
Nicole
BI Programmer/Analyst
Consultant