Hi,

I'm trying to write a code like this:

If cells(x,x).value = any cell in the range (it's a named array) then store this value (of cell(x,x)) in sheet y

Thanks