That will return something like "Sheet1" which is the codename of the sheet
unless you went through the properties and changed the (Name) of the sheet.
Pretty much as soon as I start any new Excel/VBA project I go through and
rename the CodeNames of all of the sheets. I alway prefix the sheet names
with "sht". So when you look through my code it is full of
shtMySheet.Range("A1").???
This makes the code very compact legible and bullet proof...
--
HTH...

Jim Thomlinson


"Bill" wrote:


Thanks a lot.
If I want to know the object of a sheet, it appears I can use:

sheets("Bill").codename

Is that correct?

Bill


*** Sent via Developersdex http://www.developersdex.com ***