syntax for call a sub

[rob_sheeds]

Hi,
I have a sub that needs calling....

End With
Mail_workbook_Outlook_1
End Sub

(this obviuously doesnt work) can someone tell me what im missing.
CHeers

 

[jeffreybrown]

Is that the name of the sub, it should work if you have a macro with that name.

Although, not required, I like to use the reserved word of Call which helps identify exactly what I am doing.

Call MyMacro

 

[rob_sheeds]

i tried

End With
Call Mail_workbook_Outlook_1
End Sub

but that didnt work?
Maybe the sub isnt in this book? Would that be why?

 

[jeffreybrown]

It's possible.

Try this...

Highlight Mail_workbook_Outlook_1 >> Shift + F2

If Mail_workbook_Outlook_1 is in the workbook your cursor will jump to the procedure.

 

[rob_sheeds]

i put in another module into the new book....seems to be working so far....will let you know
Cheers

 

[shadow12345]

It's possible.

Try this...

Highlight Mail_workbook_Outlook_1 >> Shift + F2

If Mail_workbook_Outlook_1 is in the workbook your cursor will jump to the procedure.

This might be the best news I have had tonight. I didn't know about shift F2