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?