Calling Macros from a Macro

Hi all,

I am having some difficulty "calling a macro from a macro"

Please Login or Register  to view this content.

Above is the start of the macro I would like to call.

I assume that in order to call this macro I need to state the worksheet, range, and Title.

How would it be best to do this in VBA?

Thanks very much!!

Is this what you mean?

Please Login or Register  to view this content.

Where are you calling it from?

Maybe:

Call Macroname

Hi all.

Thanks for your reply.

I'll explain a bit more.

Call Macroname and Application.run makes sense however I need to define three objects in order to create a line chart -
- The worksheet
- The range for the data I want in my chart
- The title.

As you can probably tell I am a novice when it comes to VBA.

So say I want to get the macro to create a chart called 'Cars' from columns A2:B200, form a worksheet called 'Sheet 1' how would I do that?'

Hi Norie,

Thanks for your help.

When Call the macro I need to define -

Please Login or Register  to view this content.

Is it just a case of writing

Please Login or Register  to view this content.

?

When I do that i receive a compile error.

Thanks again for your help.

I did, but unfortunately nothing happened

Hmmm ok. I'll have a look into it. It could be a problem with the macro. Thanks very much for your help, much appreciated

Sorry for the late reply but it worked! Thanks