macroNubee
New Member
- Joined
- Apr 9, 2002
- Messages
- 5
hi,
does anyone know why the statment
Worksheets(1).Name
give an error even when that sheet exists.
It works fine on most of my workbooks, but
in some workbooks, I can run
MsgBox Worksheets.Count
and know there are worksheets in the workbook, but I get an error when I try to access any of their names.
Thanx
does anyone know why the statment
Worksheets(1).Name
give an error even when that sheet exists.
It works fine on most of my workbooks, but
in some workbooks, I can run
MsgBox Worksheets.Count
and know there are worksheets in the workbook, but I get an error when I try to access any of their names.
Thanx