Chip

Would that be:

Send = ActiveWorkbook.Name
Public Send As String

?

Thanks

John

"Chip Pearson" wrote:

John,

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

Public Send As String