"Catch 22" wrote in message
...
I have a 150 sheet workbook and I am linking (right term?) using (=) every
A1
Cell in the work book (except my first page that I use as a directory of
sorts) to a cell in the directory. This way I only have to type in the
text
once...BUT....I would like to convert this A1 cell now into text so I can
use
SendMail (these cells refer to an email address). Is there any way to
convert
this formula to text so it doesn't read "=Directory!G22", etc. and
actually
read the actual email address or is there a way to tweak the Macro to for
Sendmail to allow for this.... Long question I know but I would greatly
appreciate any help!

Selct the cell(s), copy and then selct Edit|Paste Special.. Select values
and press OK. You probably want to do this on a copy of your workbook.

/Fredrik