I have the below code for my Excel spreadsheet
Please Login or Register to view this content.
I'm seeking assistance to find out how I can insert a carriage return in the output.
Any help would be greatly appreciated.
Thanks!
I have the below code for my Excel spreadsheet
Please Login or Register to view this content.
I'm seeking assistance to find out how I can insert a carriage return in the output.
Any help would be greatly appreciated.
Thanks!
Last edited by tbrookes3; 06-28-2017 at 10:51 PM.
Type ' & vbCrLf ' at the end of every line
Sorry for a silly question but I don't know much about VBA. Do you mean literally every line - like this??
Please Login or Register to view this content.
Last edited by tbrookes3; 06-28-2017 at 10:51 PM. Reason: Fixed code tags as per Rule 3
Try change to
Please Login or Register to view this content.
Last edited by jindon; 06-28-2017 at 11:09 PM.
Sincere apologies for incorrect tagging of code. I'm very new to this. Hopefully, I have done it right.
Thankyou for your help. I'm now realising that because of the amount of text; that I need to have a carriage return and a blank line between each output. Is this possible?
I'm out for about 2.3 hrs.
If you upload a wokbook with your desired results. it may help.
Hello
Please find attached an example workbook. I am using the following macro:
Thanks for all your helpPlease Login or Register to view this content.
Last edited by tbrookes3; 06-29-2017 at 02:16 AM. Reason: added workbook
Workbook attached this time!
Last edited by tbrookes3; 07-02-2017 at 11:02 AM.
And how do you want it?
I need to see your desired result.
At the moment, with the current vba coding, it looks like it does in the attached Example2 Column BB, but I want it to look like it does in Column BC. Hope that makes sense?
Last edited by tbrookes3; 07-02-2017 at 11:03 AM.
Just change to
Please Login or Register to view this content.
Thankyou!! This should work perfectly.
It worked perfectly in my example spreadsheet but when I tried it in my real spreadsheet I got a what is a run-time error '13': Type mismatch
Could it be because my spreadsheet is too big? It has 11,000 rows.
Thankyou for all your help so far.
Hello
Copy your original file and open it then delete all the rows except 20 for example to make it lighter and easier to upload .. and upload it
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Possibly you have Error value somewhere or join text exceed the limit.
Hello, I've done this and will upload the file in a minute. When I delete all the rows except the first 20, it works fine. Could it be because there are so many rows? 11,000 in my original spreadsheet?
Is there a way to find out what the join text exceed limit is? This might be my problem.
No, deleting rows mean nothing.
Unless I see the data, I can't do anything.
Can you just upload a workbook with 2 columns only ?
Sure, let me try that... just give me a few minutes
Sure, let me try that... just give me a few minutes
Last edited by tbrookes3; 07-02-2017 at 11:09 AM. Reason: added workbook
OOps, sorry I need to see 3 columns like your original thread.
https://www.excelforum.com/excel-pro...e-records.html
OK, here's my updated spreadsheet. Hope this makes sense.
You have more than 10000 length of concatenated character in some cell, so it will be the problem.
Displaying to the immediate window is no problem but in the range... I got no response.
Please Login or Register to view this content.
Hello, is there any way to change the code so that it says something like "More..." where the text exceeds 10000 characters?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks