Help, please, with extracting numbers from strings in VBA

[shennin202]

Hi, All,

If someone could help, I'd really appreciate it,

I have about 24 Workbooks with 12-14 sheets that have a row which contains weights entered as formulas to display the total of two weights, e.g.,

Please Login or Register  to view this content.

,

Please Login or Register  to view this content.

, etc. Some cells in the rows are empty, so I'm trying to loop thru the ranges and parse out the two figures on separate lines, e.g. if Cell E2 has

Please Login or Register  to view this content.

, I'd like to get E2 to have "1664" and E3 to have "281" as values. I've already figured out how to consolidate the rows from the various worksheets into one Sheet and replicate the rows for the parsed values, but trying to figure out the VBA is getting me stuck. I've tried the following code, could someone please have a look and see what I'm doing wrong? A sample workbook is also included with attached macro.

Please Login or Register  to view this content.

201201MonthlyHelp.xlsm

Thanks for any helpful suggestions!

[protonLeah]

Please Login or Register  to view this content.

[AlphaFrog]

Another one.

Please Login or Register  to view this content.

[shennin202]

Wow, THANKS, Y'all, BOTH solutions work like a charm! Guess I have a long way to go and a lot to learn...

Alpha, am I correct in guessing the v variant is creating an array? That's something I've read about, but had no idea how to implement, thanks for the tip!

I'm not worthy, I'm not worthy.... but workin on it!

[AlphaFrog]

You're welcome.

Alpha, am I correct in guessing the v variant is creating an array? That's something I've read about, but had no idea how to implement, thanks for the tip!

The Split command returns an array. The v variable of type Variant receives the result.