Hi, May I know is there any function to return the sheets number?
I want have like 50 sheets, everysheets has a title of Table - 1 ******, Table - 2 ******
I am thinking of doing Table - =getsheetnumber() ******* some sort of function, so I dont have to type the number again everytime i rearrange the page for printing purpose. Thank you!
See if this will work for you...
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi, thanks! But I return the sheet title instead of the sheet number. What I mean is the sheet position counting from the 1st sheet. Thanks. I found a function called sheet() but only 2013 excel can use, mine is 2010. Any other way? Thanks
like this?
Please Login or Register to view this content.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks