Hello, guys!
I am trying to do a macro that checks if the length of a row is more than 3 characters, if that's correct - merge that field with another 45 into a third one. However, I really got lost so I'd need your help. This is what I got so far.
Question is how can I specify these 45 rows to be merged with that "M1"?
Please Login or Register to view this content.
Got really lost...
Last edited by hit1234; 04-08-2013 at 08:26 AM. Reason: Use code tags in future.
Hi and welcome to the forum,
According to forum rule number 3, codes must be wrapped with code tags, and we can't help you before you fix it.
Cheers,
If I have helped, Don't forget to add to my reputation (click on the star icon below the post).
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved).
Use code tags when posting your code.
Thank you very much!
I was wondering 5 minutes ago if I can use inline code tag or something.
Kind regards,
It will be good if you explain with the help of a sample file. Just dummy data will do, as long as the format matches the original file.
To Attach a File:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thank you Mayda.
Since hit1234 is a newbie to the forum, i added them for him.
Thank you very much once again.
Just spent a couple of minutes to get to know the posting system, quite nice indeed! I will stick to them in future.
I just uploaded the file with dummy data, it was my bad for not posting one, thank you for pointing that out.
So the comment could be spread over several rows, and I would like to merge them together based on country characters. For instance, if the country code is greater than 3 characters(e.g. chn), it will merge all the fields containing information about user's comment.
Cheers arlu
@hit1234:
If you want to merge for example the range A1:B5 you can use this simple line of code:
Please Login or Register to view this content.
First I have to check if the data is less than 3 characters and then merge, otherwise there could be duplicates cause of incorrect data input.
You can use the VBA.len function to check the length of the string in the cell.
Yeah, but I still don't know how paraphrase it.Please Login or Register to view this content.
What do you mean by that?Originally Posted by hit1234
Struggling with the syntax, I am just reading online trying to get myself familiar with it.
The example you wrote was correct.
Fixed it with: =IF(LEN(M5)>=5;"0";CONCATENATE(((M5)&(N5))))
Would be nice if I get my head around that VBA macro thingy though.
You mean you want to convert your formula into vba?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks