Set Variable in Cell.Find / Loop

Hello guys,

I am just starting to write code in VBA and would need some help on this one! I have looked in similar threads / forums without any luck

What I want to do is basic:

Set a variable H2 + Selection.End(xldown)
Loop through the cells of that variable range
For each cell Use Cells.Find (to find same value in another ws)
If cell found in other ws then
'blabla
If not
'Next cell

I can manage the loop, but need some guidance for the variable range in Cells.Find
I have seen some solutions where you can use find depending on 1 cell value, but nothing with "selection.end xl down" / loop

I would be very grateful of any help!

Thanks
Aucho

Something like this, maybe?

Please Login or Register  to view this content.