| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
stupid cryptic messages
can someone explain to me why this isn't working and what the error message
compile error: Object required. Sub tester() Dim cntr As Integer Set cntr = ActiveWorkbook.Names.Count End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
stupid cryptic messages
Set is only used for objects, hence the message. Change to:
cntr = ActiveWorkbook.Names.Count hth, Doug "Jonathan Cooper" wrote in message ... can someone explain to me why this isn't working and what the error message compile error: Object required. Sub tester() Dim cntr As Integer Set cntr = ActiveWorkbook.Names.Count End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stupid | New Users to Excel | |||
| Cryptic message | Excel Discussion (Misc queries) | |||
| refedit control cryptic returned value | Excel Programming | |||
| Stupid, stupid question.... | Excel Programming | |||
| Stupid | Excel Discussion (Misc queries) | |||
Hybrid Mode
