John,

Declare the variable outside of a macro, in a general code module.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"John Baker" wrote in message
...
Hi:

I have encountered a slight difficulty (or maybe irritation) in Excel. I
executed a macro
line thus:

send = ActiveWorkbook.Name

and kind of assumed that send would always represent the active workbook
name until I
changed it. Imagine my disappointment when I found that the next macro I
executed has no
clue what "send" represented. Is there some way in Excel that I can set a
GLOBAL Variable
that all macros will know and understand?

Thanks

John Baker