Mike you are correct, but I should have mentioned that the 'zeros' were
the
result of a direct reference to column 'AR' in the corresponding row. I
must
restablish the reference (i.e. =AR11, AR12, AR13 ...) the corresponding
row.

Are you saying that Column V and Column AR are showing the same information?
Or did you mean that Column V has a formula in it and in that formula
somewhere is a reference to Column AR for the same row? In other words, for
Row 11, do you really have the formula =AR11 or is the formula more involved
than that? If you really have = AR11, then Ryan's code should work for you;
otherwise a more involved routine will probably be needed.

--
Rick (MVP - Excel)