Read contents of #Name cell

[DzednConfsd]

My spreadsheet has imported text data and unfortunately the text in
one cell begins with an = sign which gives a #NAME error on the
spreadsheet. In VBA I simply want to read the contents of the cell
and put a single apostrophe in front of it to get rid of the #Name
error. When reading the cell I either get Error 2029 or if I use
the.text property I get #Name. How can I get to the contents? (which
is =--The service line has been turned off)
Here is what I want to do.
Cells(x,7).Text = " ' " & cells(x,7).Text
THANKS

 

[Clif McIrvin]

My spreadsheet has imported text data and unfortunately the text in
one cell begins with an = sign which gives a #NAME error on the
spreadsheet. In VBA I simply want to read the contents of the cell
and put a single apostrophe in front of it to get rid of the #Name
error. When reading the cell I either get Error 2029 or if I use
the.text property I get #Name. How can I get to the contents? (which
is =--The service line has been turned off)
Here is what I want to do.
Cells(x,7).Text = " ' " & cells(x,7).Text
THANKS

Try Cells(x,7).Formula = " ' " & cells(x,7).Formula

 

[DzednConfsd]

Try Cells(x,7).Formula = " ' " & cells(x,7).Formula

In the immortal words of Homer Simpson

D' OH


THANKS

 

[Clif McIrvin]

Try Cells(x,7).Formula = " ' " & cells(x,7).Formula

In the immortal words of Homer Simpson

D' OH

's OK. That one took me a while to learn, myself!

THANKS

You're welcome.