Call with identifier populated from worksheet value using VBA

[MikeFromCedar]

I have been trying to use a Call with a variable to access other functions in Excel vba. I can access the cell contents but cannot assign it. The compiler states an error "Expected: identifier". Any ideas or thoughts?


Do While j < numberOfSections + 1


functionCall = ThisWorkbook.Worksheets("IMAGES&SUPPORT").Range("F" & j).Value

.TypeText (functionCall) 'THIS TYPES THE TEXT I EXPECT

Call (functionCall) 'THIS LINE CAUSES THE ERROR


j = j + 1

Loop

End With

 

[GWteB]

Hi MikeFromCedar,
welcome to MrExcel!

Instead of this
Call (functionCall) 'THIS LINE CAUSES THE ERROR
try this

Application.Run functionCall

 

[MikeFromCedar]

Thank you, I will try this in my next iteration of the code I am working and provide future updates.

 

[GWteB]

You are welcome and thanks for letting me know.