Re: highlight duplicate rows with fixed range
Quoteu have given me the code of a complete row 1
That workbook only had 4 columns (B to E) to create the primary key from. That code won't work on the file in this thread as there are 8,996 columns (A to MHZ) to join to make a primary out of which is simply just too much for Excel to handle hence you get an out of memory error message. Like I said there is nothing I can suggest.
Hope that makes sense and like I said good luck with it.