The best way is to reference a worksheet by its name because you can move the
order of the worksheets and then the macro will not work.

use either
worksheets("Sheet2")
or
worksheets(2)
or
sheets("Sheet2")
or
sheets(2)



"WLMPilot" wrote:

I have multiple worksheets, in my workbook, each renamed from original
"Sheet#" name. Is there a way to still reference each sheet in a macro as
Sheet1, Sheet2...., or can you only reference them by their current
caption-name?

Thanks,
Les