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!

"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

Hi ...Catch 22...
In rereading looks like the only thing you were concerned about
is email addresses which would give you no problems converting
to values as described by Fredrik.

For numeric values you could have a problem with a value like
48.05038 but you only see 48.05 in Excel and you want to
see 48.05 when printed in email. One way to solve that would
be to use cell.text in your macro where cell is a single
cell range that you are looping through cells.

Strictly within Excel there is no problem because converting
to value is not going to change the formatting.


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Fredrik Wahlgren"
wrote in message 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.

Thanks to the both of you....a big help

"David McRitchie" wrote:

Hi ...Catch 22...
In rereading looks like the only thing you were concerned about
is email addresses which would give you no problems converting
to values as described by Fredrik.

For numeric values you could have a problem with a value like
48.05038 but you only see 48.05 in Excel and you want to
see 48.05 when printed in email. One way to solve that would
be to use cell.text in your macro where cell is a single
cell range that you are looping through cells.

Strictly within Excel there is no problem because converting
to value is not going to change the formatting.


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Fredrik Wahlgren"
wrote in message 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.