Hi Fellow Forum Members
I need help with the modification of a UDF that was provided for me. The UDF basically converts values like "365SS+4wks, 175" to "365, 175". Where I need the UDF changed is allow values such as "23,456,567,666" to remain as shown. Here is a copy of the UDF:
Any help would be appreciated.
Please Login or Register to view this content.
Tony
Last edited by Paul; 12-12-2013 at 04:33 PM.
If its not meant to effect cells like that why don't you check for that format before "calling" the function?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Suggest you post a sample workbook with ALL the expected formats and what you want to see from the UDF.
Who provided the UDF? Maybe you can PM them and get them to look at it for a quicker answer.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi All
Many thanks for the feedback. I have just managed to find the contact details of the person who provided the UDF a few years ago. I will contact them.
Thanks again.
Tony
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks