[Solved] VBA: Getting the active sheetname

elf108 · Aug 12th 2003

Need help in getting the active sheetname
so that i can verify it in my code and
do different code base on the sheetname
thanks in advance

Laan · Aug 12th 2003

Hi, I don't know if i get you correctly, if you want to get the name of the active sheet, try this code:

**Include this in your code:

sheetname = ActiveSheet.Name
workbookname = ActiveWorkbook.Name

-- hope this helps

Ivan F Moala · Aug 12th 2003

???

msgbox ActiveSheet.Name

elf108 · Aug 12th 2003

thanks that was fast.

and easy too

Participate now!