how to call vba code in a macro

[SKV]

I have written a code in a Module "ABC" under function "Public Sub CreateRank()"

Now I am trying to call "CreateRank()" in my macro but not able to run it.

I tried options such as RunCode, openModule but nothing works.

Please advice.

 

[SydneyGeek]

Change it to Public Function and you should be able to run it from a macro.
But why are you using a macro to run it, if you already have the VBA routine?

Denis