Excel VBA - get worksheet name

[nyc_guy]

Is there a quick way to get the worksheet name? I am currently using
inputbox to enter the sheet name myself. I would rather have the cod
get it so I don't have to change the code when the name of the shee
changes

 

[Ron de Bruin]

Hi nyc_guy

You can use ActiveSheet in you code
ActiveSheet.PrintOut for example to print the ActiveSheet

 

[Ron de Bruin]

ActiveSheet.Name will give you the sheet name