Macro to find text from a range in another range and fill a cell accordingly

[aspadaro]

Hello everyone,

I am learning VBA programming and would like to receive feedback on the following macro, that should find text (a size expressed as eg. 300x200) from a range into another range (which contains a technical description including size) and if it does so then fill a column (blank) with the size found. Apparently it executes without filling any of the destination cell. Could you please help me understand why it doesn't work?

Please Login or Register  to view this content.

Thanks,

Angelo

[davesexcel]

I made the ranges smaller for testing purposes.

Please Login or Register  to view this content.

[aspadaro]

Thanks for you reply davesexecl. It didn't work. Still empty cells. Any other idea?

Thanks again!

[AliGW]

Thanks for adding the code tags.

[aspadaro]

You're welcome

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.





To add a file to a post