Hi,
question:
i have named range in name manager:
S_EnabledTopologiesCount where formula is:- so dynamic formula referencing to another named range.
=IF(COUNTIF(S_EnabledTopologies;"No")=7;0;1)
and from VBA this is only one way to refer to this variable?
??Evaluate(ThisWorkbook.Names("S_EnabledTopologiesCount").Value)
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.debug.Print activesheet.range("S_enabledTopologies").cells(1,1).Value
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
jaryszek 
Register To Reply
Bookmarks