Read contents of #Name cell
 

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

Read contents of #Name cell
 

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


--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)

Read contents of #Name cell
 

On Jun 23, 11:46*am, "Clif McIrvin" wrote:
"DzednConfsd" wrote in message

...

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

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)

In the immortal words of Homer Simpson

D' OH


THANKS

Read contents of #Name cell
 

"DzednConfsd" wrote in message
...


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

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)

In the immortal words of Homer Simpson

D' OH

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

THANKS

You're welcome.

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)