Read contents of #Name cell

  • Thread starter Thread starter DzednConfsd
  • Start date Start date
D

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
 
DzednConfsd said:
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
Click to expand...


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

In the immortal words of Homer Simpson

D' OH

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

THANKS

You're welcome.
 
Back
Top