Menu

#NAME? Error Fix?

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.programming

Don Guillett[_4_] Don Guillett[_4_] is offline

Don Guillett[_4_] is offline

external usenet poster

Posts: 2,337

Default

#NAME? Error Fix?

Glad to help

--
Don Guillett
SalesAid Software

"Martin Just" wrote in message
...
Perfect! Thanks so much!

"Don Guillett" wrote in message
...
Let us know if this works.

Sub cleanitup()
For Each c In Selection
x = c.Formula
If c.HasFormula Then c.Value = Right(x, Len(x) - 4)
Next
End Sub

--
Don Guillett
SalesAid Software

"Martin Just" wrote in message
...
Hi all. I'm importing a bunch of data from a .csv file. The host
application is not able to delimit the Customer Name field correctly,
so
for
some record types, I get values that look like:

=-- John Smith

Excel interprets this as a bad formula and returns #NAME? in the cell.
I'm
trying to remove the leading characters using

If Left(ActiveCell.Value, 1) = "=" Then
ActiveCell.Value = Right(ActiveCell.Value,
Len(ActiveCell.Value) - 5)
End If

but get a Type Mismatch error. Any ideas how to tell Excel they are
not
formulas?

Thanks much!

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Counting instances of found text (Excel error? Or user error?)	S Davis	Excel Worksheet Functions	5	September 12th 06 04:52 PM
Automation Error, Unknown Error. Error value - 440	Neo[_2_]	Excel Programming	0	May 29th 04 05:26 AM
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste)	Tim[_36_]	Excel Programming	4	April 23rd 04 02:53 AM
Error 50290: Error writing to Worksheet while using an ActiveX Control	emblair3	Excel Programming	3	February 24th 04 06:03 PM

All times are GMT +1. The time now is 08:13 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement