View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Toby Erkson Toby Erkson is offline
external usenet poster
 
Posts: 32
Default Using an index with a class module?

Oops, copied the wrong code. This is the correct code module I'm using:
----- Code Module -----
Sub test()
Dim mySheet As BISheets, x As Long

Set mySheet = New BISheets
mySheet.Find
For x = 1 To mySheet.Count
MsgBox mySheet.Name
Next
End Sub
----- End -----

"Toby Erkson" <t o b y e a t b i d a t a d o t n e t wrote in message
...
... My testing code module. This will properly display the two worksheets
out of 10 in my test workbook:
----- Code Module -----
Sub test()
Dim mySheet As BISheets, x As Long

Set mySheet = New BISheets
BISheet.Find
For x = 1 To mySheet.Count
MsgBox mySheet.Name
Next
End Sub
----- End -----
The fact that the .Name and .Item even work was a wild leap on my part
based...