How do I loop through each CELL in a named range and compare to another range for matches?

Hi,

I have ListBox on a UserForm that pre-loads items from a list ("TheList") and then pre-loads the already selected items on that list from another list ("TheListSelected"). It works perfectly except for one little thing. I would like to relocate the TheList to another sheet but the code uses CELL and OFFSET and I don't know how to get them to read from a range on another sheet.

I've attached the file, but the code I ned to change is pasted below in bold:

Please Login or Register  to view this content.

Is this just a small tweak of code?

Lawrence

Thanks! And I thought CELL was a method. <rolling my eyes>

What about in Userform_Initialize how do I change If cell.Offset(, 2).Value = cell.Value

Such that If cell.Offset(, 2).Value refers to seperate range called "TheListSelected"?

Lawrence

Would it be something like:

Please Login or Register  to view this content.

Lawrence