Quote:
Originally Posted by macropod
I'd prefer to work with sheet names. That way, if someone re-orders the worksheets, the code won't try to process the wrong one.
|
The reason I suggested using the worksheet's index is the OP said:
Quote:
|
It's always and only the first sheet I'm applying this to , by the way.
|
However, the fact that the user can change the both the sheet's order and name (if workbook structure is left unprotected) is why I suggested using the sheet's codename instead, because that cannot be changed by the user unless the user goes into the VBA IDE. This would be my preference.
08-05-2012, 11:29 PM
Similar Threads
Run-time error '91': Object variable or With block variable not set
Windows 7 32bit 
Office 2010 32bit
Threaded Mode