Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: "Volatile" use of concatenated worksheetfunction expression
Help urgently needed for this:
Sub x() Dim a As String Dim b As Variant ReDim b(1 To 2, 1 To 1) b(1, 1) = 1 b(2, 1) = 2 a = "Sum" 'This Works fine: "3" MsgBox WorksheetFunction.Sum(b) 'This does not work: "WorksheetFunction.Sum(b)" 'I need to "force" an evaluation of the expression "WorksheetFunction.Sum(b)" MsgBox "WorksheetFunction." & a & "(b)" End Sub Thanks a lot in advance ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
whyis "paste spl" copying concatenated cell changing lastdigit2 0 | Excel Worksheet Functions | |||
CELL("filename") acting Volatile? (in assoc. with PULL) | Excel Worksheet Functions | |||
How can I get "=TODAY()" results to be non-volatile? | Excel Worksheet Functions | |||
=CELL("filename") VOLATILE? | Excel Worksheet Functions | |||
Excel expression "sumproduct" in Access | Excel Programming |