Hi,

I have a database with 70 columns and need to get rid of rows with identical
information.

I just recored the following macro, but it is lenghthy + there is 256 char
limitation.

ActiveCell.FormulaR1C1 = "=RC[-70]&RC[-69]&RC[-68]&RC[-67] .... so on"

Is there is a way to do it differently?

Thank you
--
______
Regards,
Greg