Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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

excelmacros-vba
MS Office Version: 2016
posted by: wifi47 (rep: 2) on Fri Jan 22, 2021 at 9:38 am
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
posted by: John_Ru (rep: 6142) on Fri Jan 22, 2021 at 10:08 am
Discuss

Discussion

P. S. When you post your next question, please use a more descriptive title (it helps us and otbers) 
John_Ru (rep: 6142) 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