Coverting Formula to Text

C

Catch 22

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!
 
F

Fredrik Wahlgren

Catch 22 said:
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!
Click to expand...

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
 
D

David McRitchie

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" <[email protected]
 
C

Catch 22

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

David McRitchie said:
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" <[email protected]
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.
Click to expand...
Click to expand...
 
Top