Searching through a non-contiguous range

I have a UserForm for updating details on a sheet by searching for a reference in a range and updating the cell to the right of that using offset. I'm using this method to elimate the dreaded human error factor.

I found the below code down the back of the internet and have adapted it to suit my workbook. It uses a string (in TextBox_Reference) and searches in column R and stamps the value from Textbox_Date to the corresponding cell (next column over).

I need to somehow adapt this so if it doesn't find the value in column R it checks V and then Z and then AD. In reality there will be many columns to check.

Could someone please help me amend this so it searches through a non-contiguous range?
Each column in the range will start from row 2 and end at the same "LastRow" which is defined earlier in the code.

Many thanks in advance.

Kerry.

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Hi there,

It's not easy to test this without access to your worksheet and UserForm, but try using the following code as a replacement for the code you've posted:

Please Login or Register  to view this content.

The highlighted values can be changed, deleted or added to as per your requirements.


It's also likely that this statement can be simplified to:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M