Hmm I guess I'm not quite sure what you're trying to do...whatever it is, my solution should have worked. I thought you were trying to carry over and assign a variable in multiple worksheets.

__________________
TC
Current stable:
- 2004 Mazda RALLYWANKEL
- 2007 Saturn sky redline
- 2004 Explorer...under surgery.

Past: 135i, GTI, 300E, 300SD, 300SD, Stealth