RyanScharfy
Technical User
Okay, I'm full of questions today. My next issue. I've created an excel workbook with multiple worksheets. I'd like the worksheet name to automatically be inserted in cell A1. Any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to reference a sheet name in cell A1 in excel 1
- Thread starter RyanScharfy
- Start date
- Status
-
1
- #2
SkipVought
Programmer
Hi,
VOLA! 
Skip,
Skip@TheOfficeExperts.com
Code:
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))Skip,
Skip@TheOfficeExperts.com
- Thread starter
- #3
SkipVought
Programmer
Geoff,
Nope.
Would have given you credit if it had been.
Skip,
Skip@TheOfficeExperts.com
Nope.
Would have given you credit if it had been.
Skip,
Skip@TheOfficeExperts.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
