How can I copy the name of the worksheet tab to a cell in the worksheet?

By Saud Rana

macro,sheet,text

Run a macro that has this line:
ActiveCell.Value = ActiveSheet.Name
this is a very easy work in Excel Run a macro

How can I copy the name of the worksheet tab to a cell in the worksheet?  (608 Views)