Hey all
I have found this code online that helps me a lot with my work but when using it I found a problem with it. The code is meant to split text to max 16 characters per string and continue it in the next column. The small problem I have is that it sometimes turns some of the new strings into dates instead of keeping in a text format. Do anyone of you have a fix to this?
On in the file, the different sheets have a wrong(1), a right(2) and before macro(3).
Last edited by nicolaj.juul; 02-09-2019 at 02:35 PM.
Change last part of code to something like...
Note: Array(1, 2), First part means column#, 2nd part means data type, 2 = Text.
Please Login or Register to view this content.
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
Hi, welcome to the forum, and thanks for the title change
Last edited by FDibbins; 02-09-2019 at 04:58 PM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks