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