I want to run a Macro that starts in "the current" WS, briefly jumps to a
different WS (always the same one) Grabs the Format of a particular Column,
and returns to do a Paste Special. I need to be able to capture the Name of
the current WS into a Variable at the top of the Macro, so that I can return
to the correct WS to continue.

Help, please!
--
Dave
Temping with Staffmark
in Rock Hill, SC