Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way to grab the "Computed Value" or "Result" of a Named Formula
with in a Worksheet with VBA? WorkSheet Name: Min=((HOUR(Time_End)*60+MINUTE(Time_End))-(HOUR(Time_Start)*60+MINUTE(Time_Start)))-Time_Break Sub Grab_Minute() Dim n As Name Dim Computed_Value As Long i = 1 For Each n In Names If n.name = "Min" then Computed_Value = *Compute*(n) End if Next n End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
EXCEL07 CELL FORMULAS WILL NOT COMPUTE TO A VALUE | Excel Worksheet Functions | |||
Named ranges and pasting formulas with named references | Excel Programming | |||
Formulas cut and paste but do not compute | Excel Worksheet Functions | |||
formulas will not compute | Excel Worksheet Functions | |||
Formulas that don't compute | Excel Worksheet Functions |