This should be very simple... if you know what you're doing.
I just need to run a macro using the root of the name... Im_Dot_ and then add the number of the dot to the end of the name.
For example: I need to call the macro named Im_Dot_13.
The number 13 is derived by a loop of variables from 12 to 23. I designated this number as DotNum.
I've tried Application.Run ("Im_Dot_" & DotNum), but this doesn't work.
Either using Application.Run or Call... how would I run this macro? Thanks.
I just need to run a macro using the root of the name... Im_Dot_ and then add the number of the dot to the end of the name.
For example: I need to call the macro named Im_Dot_13.
The number 13 is derived by a loop of variables from 12 to 23. I designated this number as DotNum.
I've tried Application.Run ("Im_Dot_" & DotNum), but this doesn't work.
Either using Application.Run or Call... how would I run this macro? Thanks.