How to insert a Macro within a macro?
 

I have a sub Format()

and I want another macro called: AddRows()

To run in the middle of the sub Format()Macro.

What I did doesn't work.
I had Sub Format()
.....
.....

Sub AddRows()
End sub

.....
End Sub.

How can I do this?

try

Sub Format()
stuff
call AddRows()
End sub


--
Don Guillett
SalesAid Software

"Thrava" wrote in message
...
I have a sub Format()

and I want another macro called: AddRows()

To run in the middle of the sub Format()Macro.

What I did doesn't work.
I had Sub Format()
....
....

Sub AddRows()
End sub

....
End Sub.

How can I do this?

Ahhaah,
Thank you


-----Original Message-----
try

Sub Format()
stuff
call AddRows()
End sub


--
Don Guillett
SalesAid Software

"Thrava" wrote in
message
...
I have a sub Format()

and I want another macro called: AddRows()

To run in the middle of the sub Format()Macro.

What I did doesn't work.
I had Sub Format()
....
....

Sub AddRows()
End sub

....
End Sub.

How can I do this?



.

actually when I copied yours I forgot to remove the () after addrows.
It can be

call adrows
or just
adrows


--
Don Guillett
SalesAid Software

"thrava" wrote in message
...
Ahhaah,
Thank you


-----Original Message-----
try

Sub Format()
stuff
call AddRows()
End sub


--
Don Guillett
SalesAid Software

"Thrava" wrote in
message
...
I have a sub Format()

and I want another macro called: AddRows()

To run in the middle of the sub Format()Macro.

What I did doesn't work.
I had Sub Format()
....
....

Sub AddRows()
End sub

....
End Sub.

How can I do this?



.