RANGE MACRO
Since Range1 is cells A3 - E3 and Range2 is cells A4 - E4 the 2 ranges are
different. Did you want to know if they contain the identical values. If so
then do they have to occure in the same order? Do the formats have to be the
same? Do you really want to delete the range or just clear the contents???
--
HTH...
Jim Thomlinson
"Joseph Weber" wrote:
I am trying to compare two ranges of data. if those ranges are the same i
would like to delete one of them because it is a dup. How do i do this in
macros. what would be the syntax. i tried:
Range("A3:E3").Select
ActiveWorkbook.Names.Add Name:="RANGE1", RefersToR1C1:=Selection
Range("A4:E4").Select
ActiveWorkbook.Names.Add Name:="RANGE2", RefersToR1C1:=Selection
If Range("RANGE1") = Range("RANGE2") Then Range("RANGE2").Delete
|