VBA Application.Run for Running Macros-with-Parameters Stored Inside an Excel Cell

[Paul_Hossler]

Is there any way to accomplish what I aim to accomplish?

Yes

Option Explicit


Sub test()
    
    With Worksheets("Sheet1")
        'need the .Text Edit -- or at least .Value. Can't leave as Range in the macro name
        Call Application.Run(.Range("A1").Text, .Range("B1"), .Range("C1"), .Range("D1"), .Range("E1"))
    End With


End Sub


Sub TwoTimes(P1 As Double, P2 As Double, P3 As Double, P4 As Double)


    MsgBox 2 * P1
    MsgBox 2 * P2
    MsgBox 2 * P3
    MsgBox 2 * P4


End Sub