Is there a way to count the number of worksheet like count the index?
when i use this code
it always give a value of "2"UserForm1.Spreadsheet1.Sheets(SheetName).Index
even if its a new or different worksheet
Is there a way to count the number of worksheet like count the index?
when i use this code
it always give a value of "2"UserForm1.Spreadsheet1.Sheets(SheetName).Index
even if its a new or different worksheet
Worksheets.count
You should point out that you are using a SpreadSheet control
MsgBox Me.Spreadsheet1.Worksheets.Count
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks