View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jonathan Cooper Jonathan Cooper is offline
external usenet poster
 
Posts: 28
Default 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