An example is best: I want to be able to test b6 through k6 for duplicate
values and highlight the duplicates. Then I want to test b7 through k7 for
duplicate values and highlight the duplicates. ...etc. Doing each of these
ranges one at a time is easy. But I have lot of them. I would like to use
something like $b6 through $k6 and copy to the subsequent rows. The relative
reference (6) does not increment when copied to more than one row at a time.
I used to do this in 2003 but have been unable to make it work in 2007.