Combine macros

[MIGARDEIN]

Good morning,

Is there a way to run both the Macros below with one Short cut key?

I have tried combining the Macros... something goes wrong.

I have tried:

Sub CallMacros()
CopySource
CopyTrend
End Sub

...something goes wrong.

Please Login or Register  to view this content.

AND

Please Login or Register  to view this content.

I think the problem might be that my second Macro:

Please Login or Register  to view this content.

the part in red... is not specific to a worksheet.

Anyone know how I can do that?



Thanks for any help!

[HaHoBe]

Hi, MIGARDEIN,

duplicate to closed thread (http://www.excelforum.com/excel-prog...rtcut-key.html) and pending thread (http://www.excelforum.com/excel-prog...rtcut-key.html).

Ciao,
Holger