Making proper names out of concatenated string variables

[TryToExcel]

I am trying to create proper names on the fly by concatenating variables that form a string name that can used as a substitute for predefined names as in the name of a subroutine. I want to try and get a subroutine called based on where the active cell is located by row and column number variables. The basic code is as follows:

Please Login or Register  to view this content.

I get a "Compile error" message, with explanation "Expected Sub, Function or Property" on the line "Call strSub"

Is there a work around?

Danny

[pike]

Hi TryToExcel
possibly

Please Login or Register  to view this content.

[DonkeyOte]

Generally speaking you can use

Please Login or Register  to view this content.

However, for whatever reason it won't work where the Sub Routine name is an alpha numeric string like Sub44 .. if you prefix the number with say _ it will work, eg Sub_44

Please Login or Register  to view this content.

and Sub routine is named Sub_44

However, I suspect you don't really need all the different sub routines - ie the above is an unusual approach.

[TryToExcel]

Thanks for the help, that did the trick. I tried the same technique with a "GoTo" statement for a label but it won't work. I wouldn't have to call subroutines if all my code was in the code.

Please Login or Register  to view this content.

Danny