Hi,

I'm trying to do something like the indirect function on the sheets but on VBA. I have a variable that it's value is a String and it's the name of another variable and I'm trying to call the variable.

Ex.

Sub a()

Dim SM
Dim name

SM = 1

name = SM

msgbox("name")

End Sub

I'm expecting a message box with the value of the variable SM but I don't know how I can do this or if it is even possible.

Thanks ,

juancamilo87