Hello,
I'm trying to write a UDF that takes the text in a cell and returns text with a list of forbidden characters removed from it. At the moment I have the following:
code/
Please Login or Register to view this content.
The problem is that the value in the cell comes out as '#NAME'
I'd be most grateful for any pointers you may have.
Thanks,
twills
Last edited by twills; 02-04-2010 at 08:19 AM.
What is the return type of your function?
Please Login or Register to view this content.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Hi, Try changing "Cell as string" to "Txt as string"
Regards Mick
How is thisPlease Login or Register to view this content.
This would make it a bit more genericCall with (like) =SubstituteList("&,/,*,-,|,\,],{,}",C37)Please Login or Register to view this content.
All should be seperated by comma (,)
Ricardo and Mike G,
Many thanks for your suggestions. I incorporate the return type as string as per the suggestions, but still get the #NAME being returned.
If you have the time, I've attached the worksheet in question and as always would be appreciative of any suggestions.
Many Thanks,
Twills
Copy the code.
Delete the module RemoveForbiddenCharacters (save NO)
Insert new module
paste the function
Change (Txt as String) into (Txt as Range)
Ricardo,
Many thanks for that - it works perfectly. Incidentally, why does it do this?
Thanks
twills
Don't know,
It's hard to tell in someone elses XLS files. therefore I use this method and now it works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks