View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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