Split string in array not in cell range vba excel macro

**Yajson** · 12-30-2017, 12:53 AM

Hello , I am just new in creating macro and I have a macro that my colleague created which we used in our work . But she is not working with us now and I need to do some changes.

Is it possible to get part of string in a string from other range to other cells? IS there's any code available for this? I think I need to split the data I need from column G to have the right result for column H and I. If there's any good help thank you in Advance.
example:

column G column H column I

LB230X200X45/20 20(string get from G) 200(string get from G)
LB5000X2000X40/25 25(string get from G) 2000(string get from G)

FB01O.jpg
3a3JG.jpg

**jindon** · 12-30-2017, 01:20 AM

Please Login or Register  to view this content.

If this doesn't work, upload a workbook.
Picture doesn't help at all.

**Yajson** · 12-30-2017, 03:16 AM

Hi Jindon your code is working . But I still have some concern. If you will see I have two existing rows with data.
The procedure will be like:

1. duplicate the two original data from the two rows. therefore it will have 4 rows , 2 or the first row and 2 for the second row.
2. after duplicate I want to change only the Thickness and width of the newly added rows which the data is from ProfileType Column.

it means my sheet will provide 4 different thickness and width data . the two original data as untouched and two added width and thickness data for newly added.

below is my added snapshot and code:
Untitled.jpg

Please Login or Register  to view this content.

**jindon** · 12-30-2017, 04:47 AM

1)
Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding

For normal conversational replies, try using the QUICK REPLY box below.

2) Upload a workbook with before/after clearly showing the logic. Picture will not help.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**Yajson** · 12-30-2017, 06:13 AM

Sorry I am just new .. I am trying to attached file but I don't know I cannot attach...

**jindon** · 12-30-2017, 06:19 AM

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

**Yajson** · 12-30-2017, 06:45 AM

Hi Jindon, Kindly see my code.. thank you

**jindon** · 12-30-2017, 06:50 AM

Can you just upload 2 worksheets showing before macro and after macro? I mean your desired result?

**Yajson** · 12-30-2017, 01:52 PM

Hi Jindon , I already provide in the snapshot attached in my first post.. I upload two snapshot , preliminary format and the result after code execution. Kindly see above...

**jolivanes** · 12-30-2017, 02:53 PM

Did you not read post #4 about pictures?

**jindon** · 12-30-2017, 08:38 PM

Originally Posted by jindon

If this doesn't work, upload a workbook.
Picture doesn't help at all.

Originally Posted by jindon

2) Upload a workbook with before/after clearly showing the logic. Picture will not help.

Originally Posted by jindon

Can you just upload 2 worksheets showing before macro and after macro? I mean your desired result?

No matter how many pictures you post, it will be of no help.

Hope someone else to help you.

**Yajson** · 12-30-2017, 10:24 PM

I will reupload again .sorry..

**xladept** · 12-30-2017, 10:35 PM

It's a little sloppy but seems to be a start:

Please Login or Register  to view this content.

**Yajson** · 12-30-2017, 10:51 PM

Hi Jindon I already manage to make it work . Kindly see the attached file and check.
Instead of assigning "G" in "For i = 3 To Range("G" & Rows.Count).End(xlUp).Row Step 2" , I assigned "F" to have the desire result.

I have one more question .. Can you explain to me what's the meaning of below code? It quite unfamiliar for me as new for doing this stuff. Thank you

.Pattern = "X(\d+(\.\d+)?)X.*?/(\d+(\.\d+)?)$"

**Yajson** · 12-30-2017, 10:56 PM

Originally Posted by xladept

It's a little sloppy but seems to be a start:

Please Login or Register  to view this content.

Hi XLAdept.. I will try this one...

**jindon** · 12-30-2017, 11:02 PM

If you want it like that

Please Login or Register  to view this content.

**Yajson** · 12-30-2017, 11:07 PM

Hi XLAdept. your code is working. The only thing is that it highlight the rows. But it is working well...

**Yajson** · 12-30-2017, 11:13 PM

Hi Jindon, our code is working well also .. I've learned a lot about all of your codes . But can you explain to me what's the meaning if this code so that next time I will be able to create my own syntax.

.Pattern = "X(\d+(\.\d+)?)X.*?/(\d+(\.\d+)?)$"

**jindon** · 12-30-2017, 11:16 PM

Goole first with the key words like

VBA Regular Expression meta character

**Yajson** · 12-30-2017, 11:53 PM

ok I will do. thanks this thread is closed..

**xladept** · 12-31-2017, 12:07 AM

Thanks for the rep!

Split string in array not in cell range vba excel macro

LinkBack

Thread Tools

Rate This Thread

Display

Split string in array not in cell range vba excel macro

Re: Split string in array not in cell range vba excel macro

Re: Split string in array not in cell range vba excel macro

Re: Split string in array not in cell range vba excel macro

Re: Split string in array not in cell range vba excel macro

Re: Split string in array not in cell range vba excel macro

Re: Split string in array not in cell range vba excel macro

Re: Split string in array not in cell range vba excel macro

Re: Split string in array not in cell range vba excel macro

Re: Split string in array not in cell range vba excel macro

Re: Split string in array not in cell range vba excel macro

Re: Split string in array not in cell range vba excel macro

Re: Split string in array not in cell range vba excel macro

Re: Split string in array not in cell range vba excel macro

Re: Split string in array not in cell range vba excel macro

Re: Split string in array not in cell range vba excel macro

Re: Split string in array not in cell range vba excel macro

Re: Split string in array not in cell range vba excel macro

Re: Split string in array not in cell range vba excel macro

Re: Split string in array not in cell range vba excel macro

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA code required to TRIM and SPLIT the selected Range (String)

Find value in a value range in a split string

[SOLVED] Return matching string in array if cell contains string contained in the array

macro to find text string in cell range and paste in other cell range

Excel Split Single Cell Array into Multiple Cells

Split string by line break into array

how to split a string and return array

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions