Excel VBA - get worksheet name

N

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
 
R

Ron de Bruin

Hi nyc_guy

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