John,

Declare the variable, as below, before and outside of any procedure.

Public Send As String


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

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

Thanks, but I am not quite certain how to do that.
GIven the specific variable I wish to set, can you give me the code. I am
sorry, but I am
a neophyte when it comes to complex VB things.

Regards

John Baker

"Bob Phillips" wrote:

John,

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