Run same name code on different modules

[Rudi]

Hi

As in the image, I gave a macro that must run with specific (listed) filters and then it must run again with criteria being Unlisted.

Is it possible to have the code running listed filter on one module
Have code running unlisted on another module and then refer to code like this (or similar):

Code: Select all

Sub Test()
PrepSheets
Listed.Filter2Z
Listed.Filter2NZ
UnListed.Filter2Z
UnListed.Filter2NZ
CreateTotals
End Sub

SP5-Wed,6-11.jpg

[HansV]

Yes, that is possible. Take care never to call Filter2Z or Filter2NZ without prefixing it with the module name.

[Rudi]

How do I do that?
Getting errors...

SP6-Wed,6-11.jpg

[HansV]

If you have declared Filter2Z as

Sub Filter2Z()

or as

Public Sub Filter2Z()

you can call it as

Listed.Filter2Z

But if you have declared it as

Private Sub Filter2Z()

you must use

Application.Run "Listed.Filter2Z"

[Rudi]

Many TX.