Read contents of #Name cell

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
 
C

Clif McIrvin

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


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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top