Hi,

I'm cycling through the worksheets of a workbook
extracting their name. I'm using the following code which
is "clunky" - what's a better way of doing it..??

For Each sheet In ActiveWorkbook.Worksheets

sheet.Activate
my var = ActiveSheet.Name

Next sheet

thks

Chris