Is there a formula that can get the sheet number for the current sheet? I have a workbook and the first sheet is titled "Status" and it's labeled as Sheet1 in the VBA project explorer window. I want a cells in Sheet1(Status) to display Sheet1. Is that possible?
Last edited by Ricker090; 08-14-2012 at 03:53 PM. Reason: Solved
You would need a little VBA function to get the Sheet Code Name
Place this formula in the cell you want the sheet name
Formula:
Please Login or Register to view this content.
Place this in a standard Module
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Yep, that worked. I didn't know if Excel already had a formula built in or not, but I guess there isn't one. Thanks for the User Function!
=MID(CELL("filename",A1), FIND("]", CELL("filename", A1))+ 1, 255)
Regards,
Vandan
vandan- I needed the sheet number, not the name. Thanks for the response though.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks