Macro call from another Macro
 

I have MacroNo1. I call MacroNo2, it does it's job and returns. How
can I bring back variable "TempData" from MacroNo2 and use it in
MacroNo1?

Macro call from another Macro
 

Dim it outside of the macros (in the General Declarations section of the
module where your macros are).

--
Rick (MVP - Excel)


"Fan924" wrote in message
...
I have MacroNo1. I call MacroNo2, it does it's job and returns. How
can I bring back variable "TempData" from MacroNo2 and use it in
MacroNo1?