Hi,
I'm running a macro that gets rid of duplicate entries.
Once it finishes it leaves some cells at the bottom (in column I) with #REF!
There is a formula within the cell(s) =VLOOKUP(#REF!, Sheet2!AG:AG, 1, FALSE)
Wondering if theres some code that would clear any cells in column I that has this error
thanks for any help
Jon