I created a simple function as follows:
Public Function TabName() as string
TabName = ActiveSheet.NameEnd Function
This works as I would expect, except it doesn't update when the worksheet tab name is changed - the only way to get it to update is to enter-then-exit edit-mode in the cell containing =TabName()
Can anyone explain why this is, and what I can do to make it more dynamic?
Thanks
Try this -
Please Login or Register to view this content.
Last edited by NeedForExcel; 07-01-2015 at 06:56 AM.
Cheers!
Deep Dave
Thanks - that worked perfectly.
The Help on this method states that True is the default - but this experience suggests otherwise.
@ NeedForExcel
I tested the UDF function and created three sheets (Main - Data - Report) and in Cell A1 in each sheet I put the formula
When I'm in Main sheet it's ok, but when navigate to Data sheet or Report sheet I found the cell A1 still appears "Main" and I have to double click any cell to refresh results..Please Login or Register to view this content.
Hope it is clear
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Yes - I got that, but I just added a "Calculate" in the Workbook_SheetActivate sub.
I suppose it might be an issue if calculations in one sheet were based on those from another, but in my case this isn't going to be a problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks