Hi,
question:
i have named range in name manager:
S_EnabledTopologiesCount where formula is:- so dynamic formula referencing to another named range.
Please Login or Register to view this content.
and from VBA this is only one way to refer to this variable?
??Please Login or Register to view this content.
i tried with application.range("S_EnabledTopologiesCount").value but this is not working.
Please anybody confirm,
Jacek
This is how I see it:
If your S_enabledTopologies is refering to some static range then you can directly have access to it's contents.
i.e. the first cell contents:
But as S_enabledTopologiesCount is a dynamic name (just a formula) it is treated by Excel as a kind of a reciepe. It's calculated in a worksheet "on request from recalculation", and current value is not stored.Please Login or Register to view this content.
So to access this value from VBA you (unfortunately) shall "ask for calculation of this formula" - and indeed by using evaluate you do it.
Best Regards,
Kaper
thank you for such a great explanation,
Jacek
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks