To run a macro within another macro you can use the following code:
| Code: |
Sub Macro1() 'Macro code for Macro1 Goes here Call Macro2 End Sub Sub Macro2() 'Macro code for Macro2 Goes here End Sub |
Obviously you just need to change your code to fit in!
Hoep that helps.
-------
Once a Red Bar, Always a Red Bar... Points are for lossers :)