How to enter the tab name into a cell on the worksheet?

0

I am looking for a way to enter the tab name into a cell on the worksheet?

Doug Hopps

wifi47

Post Edited
Title: Title was not descriptive.
Answer
Discuss

Answers

0
Selected Answer

Hi WiFi47.

To put it on cell B3 say, use:

Range("B3")=ActiveSheet.Name
Discuss

Discussion

P. S. When you post your next question, please use a more descriptive title (it helps us and otbers) 
John_Ru (rep: 1002) Jan 22, '21 at 10:10 am
Thanks John this is the solution I was looking for. It Works
Many Thanks
wifi47
wifi47 (rep: 2) Jan 22, '21 at 10:16 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login