Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
Owner2229
in reply to: Anonymous

Hi, the error is obvious as on the last row I have "End Sub" instead of "End Function".

 

The two code snipsets I send you in the last post are separate solutions, but you got it, right? :winking_face:

 

No I didn't create any test files for this rule, so I wasn't able ot test it. I just made it blindly :grinning_face_with_smiling_eyes:

I was ussing the picture you posted in the first post as a data source, so if you have more date in the excel file, than you'll need to adjust the code.

 

In the first solution (FS) is missing the "SIZE-DD" from your picture. But it's included in the second solution.

In FS it can be added at place where is this:

'And so on for C...  

 

It's 6th row from bottom.

If you want me to adjust the code for you then send me the excel file or tell me how many more rows and/or columns you have in it.

And if the empty/description rows are the same (two).

It can also be done programaticaly if it will vary over time.

Consider using "Accept as Solution" / "Kudos" if you find this helpful.
- - - - - - - - - - - - - - -
Regards,
Mike

"Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live." - John F. Woods