Thread
:
Calling a procedure in a procedure
View Single Post
#
2
Posted to microsoft.public.excel.programming
ALEX
external usenet poster
Posts: 493
Calling a procedure in a procedure
I did what you did and pulled the code seperate and I still get the error.
"Don Guillett" wrote:
I ran your macro, as is, with the addition of the macro below. Clicking yes
ran summary.
Sub summary()
MsgBox "HI"
End Sub
--
Don Guillett
SalesAid Software
"Alex" wrote in message
...
I'm getting the following error..
Compile Error:
Expected variable or procedure, not module
When I run my macro and it shows this part of my code....
Finish = MsgBox("Click YES to finish report, Click NO to end." & Chr(13) &
_
"Rerun the M & S Macro if you need to add more reports", vbYesNo +
vbInformation)
If Finish = vbYes Then
Summary '<----- THIS PART IS HIGHLIGHTED ON ERROR
Exit Sub
Else
MsgBox "Let me know if this macro has helped you."
End If
BTW I do have a variable for this though it's not here.
Any ideas why the error?
Reply With Quote
ALEX
View Public Profile
Find all posts by ALEX