Call a sub routine from another module

[Patricia0923]

Hi,
I am writing a lot of code and have separated each section in different modules
For example, I have one module titled OpenR2D2 and another titled StoreName

I want the sub in StoreName to run at the end of OpenR2D2 but I get this compile error
"expected variable or procedure, not module"

Here's the end of the code where I put it. What have I not thought of? Thanks so much!

ThisWorkbook.Activate
Range("B9:G9").PasteSpecial

R2D2data.Activate
Range("B7:G7").Copy 'Sch Actual VLH


ThisWorkbook.Activate
Range("B12:G12").PasteSpecial

Call StoreName

R2D2data.Close Savechanges:=False


Application.ScreenUpdating = True


End Sub

 

[Rick Rothstein]

When you use the Call statement, the parentheses are required. Try it this way...

Call StoreName()

 

[RoryA]

Don't name the module and the subroutine the same thing. Or, if you really must, you have to use

Call StoreName.Storename

 

[Patricia0923]

Hi,
Thanks for quick reply!
I actually renamed the Module.
I did not realize that having the module name and the sub routine name the same would cause a problem!
There's so much to know with VBA - are these little tricks written somewhere?


Thanks again - problem solved!

 

[Patricia0923]

Hi
Thanks for your solution and for taking the time to reply!
Problem solved!