What do you mean by 50 rows of cells to be compared? Is that the generated
number is compared against other 50, or just that you have 50 rows of data in
total? If you can be more specific on what you want to achieve, and what is
the layout of your data, we may help you better.
Regarding labels, you can fix rows and column adding a $ sign in front of
the part of the reference you want to fix. For example, $A1 will keep
looking on the A column, and A$1 won't change to other row but 1.

Miguel.

"spxer" wrote:


Two problems; 1 there are over 50 rows of cells to be compared to and 2
when I copy and paste the code, cell labels that I don't want to change
do change, which renders the code useless


--
spxer
------------------------------------------------------------------------
spxer's Profile: http://www.excelforum.com/member.php...o&userid=37025
View this thread: http://www.excelforum.com/showthread...hreadid=567497