| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using object range to call up worksheets
Why won't this work?
For Each a In DataSheet a.Select -- Nicole BI Programmer/Analyst Consultant |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| call Module from MS Excel Object - Probably very easy VB questions | Excel Discussion (Misc queries) | |||
| Can't call Excel Services UDF from macro, object not found error | Excel Programming | |||
| Recordset object loses validity in call between function & subrout | Excel Programming | |||
| call the object of scanner... | Excel Programming | |||
| Range object to Array object conversion | Excel Programming | |||
Linear Mode
