Macro calling another Macro
 

Is it possible to call one macro within another macro? If so, how? The
macros would be located in the same workbook, but different sheets


Thanks,
John

Sub Macro1()
Do stuff here maybe

Call Macro2()

Perhaps do more stuff here.
End sub

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"spartanmba" wrote in message
...
Is it possible to call one macro within another macro? If so, how? The
macros would be located in the same workbook, but different sheets


Thanks,
John

Oops:-

Sub Macro1()
Do stuff here maybe

Call Macro2

Perhaps do more stuff here.
End sub

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ken Wright" wrote in message
...
Sub Macro1()
Do stuff here maybe

Call Macro2()

Perhaps do more stuff here.
End sub

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--

"spartanmba" wrote in message
...
Is it possible to call one macro within another macro? If so, how? The
macros would be located in the same workbook, but different sheets


Thanks,
John