Run Another Macro

Qaiyum · Feb 26th 2014

Hi,

I have One Macro in one Sheet.

I want to run that Macro from another Macro, please help me in code for this.

Thanks & regards,
Qaiyum Shaikh

**StephenR** · Feb 26th 2014

Re: Run Another Macro

A Google search probably would have done the trick!

Code

Sub Macro1()
Macro2
End sub

Qaiyum · Feb 26th 2014

Re: Run Another Macro

Hi,
Thanks, But my problem is that the code was placed in Particular Sheet VB Editor Wizard not in any module. Hence unable to run that macro.
Please help.

**StephenR** · Feb 26th 2014

Re: Run Another Macro

Sorry, don't follow, what is the VB editor wizard? Can you post a workbook?

Qaiyum · Feb 26th 2014

Re: Run Another Macro

Dear Stephen,

Thanks for the information, I have created another macro where my problem was resolved with the code given by you.
However I have different Issue that I am not able to find what is wrong because I am getting a Error "Sub or Function not defined"
I am getting Error on below code in Error in "rangetoHTML"

HTML

[/B][/COLOR].HTMLBody = "<HTML> <br> </br> </HTML>" & "<html><b>Hi,</b></html>" & "<HTML> <br> </br> </HTML>" _                & " <html><b> " _                & "Please find below summary on Cash Indent and Cash Received.</b></html>" _                & "<HTML> <br> </br> </HTML>" & "<html><b><u> If any discrepancies observed, " _                & "please highlight us for further investigations & rectifications. </b></u> </html>" & _                "<HTML> <br> </br> </HTML>" & rangetoHTML(rng) & "<HTML> <br> </br> </HTML>" & _                "<html><b>Thanks & Regards</b></html>" & "<HTML> <br> </br> </HTML>" & "<b> NCR Corporation (Cash Team) </b>"[COLOR=#3E3E3E][B]

[/B][/COLOR]

**StephenR** · Feb 26th 2014

Re: Run Another Macro

Qaiyum - that looks like a separate question so please post a new thread, and if possible post some more code.

Qaiyum · Feb 26th 2014

Re: Run Another Macro

Thanks a Ton... Will do it

Run Another Macro

Participate now!

Share

Users Viewing This Thread