Excel VBA - get worksheet name

  • Thread starter Thread starter nyc_guy
  • Start date Start date
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
 
Hi nyc_guy

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