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!