Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Good Afternoon.
I have 5 Public Subs() in 5 different worksheets. I have the following code in Module 2 that I would like to use to call all 5 subs. But I keep getting a "sub or function not defined" error: CODE: Public Sub SendDataToReport() Call SendToWord Call SendToWord2 Call SendToWord3 Call SendToWord4 Call SendToWord5 End Sub /CODE: Why does this happen? How can I call all five subs from within module 2? All worksheet subs are public not private. Suggestions? Thanks for the help chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calling a module | Excel Discussion (Misc queries) | |||
calling up information from a different worksheet. | Excel Worksheet Functions | |||
Calling VBA function that is in another module | Excel Programming | |||
Calling a module function from a class method | Excel Programming | |||
Calling Macros oustide current module | Excel Programming |