Write Macro to Run Macro

[fedas18]

Hi I am trying to write a macro to run the following macros:

Sub Macro17()
Sub Macro19()
Sub Macro21()
Sub Macro22()
Sub Macro24()
Sub Macro29()

Then be taken to cell B11

Does anyone have any idea how to do this? I tried recording it but it didn't work.

Thanks!

 

[VoG]

Try

Sub CallLots()
Call Macro17
Call Macro19
Call Macro21
Call Macro22
Call Macro24
Call Macro29
Range("B11").Select
End Sub

 

[fedas18]

I got the following error:

Run-time error '438'

Object doesn't support this property or method.

Any idea?

 

[VoG]

Click Debug - which line of code is highlighted?

 

[fedas18]

Nevermind, I figured it out. It was my mistake.


Your macro worked perfectly!

Thank you very much.

Learning a new thing everyday.......