Quote Originally Posted by Bryan Hessey
That was not my question.

Can you succeed with Replace ,Sheet2!A*:B*,2,FALSE) with ,Sheet2!A1:B42,2,FALSE)
or are there similar formula working on a column that is not D?

---
Worked like a charm, you my friend kick a$$.