Woops - DON'T do the search/replace thing - Just put a $ in front of
the A in the first formula before you copy horizontally. The column
letter won't change because of the $, and neither wil the row no's
'cos your filling horizontally. However you do need them to change
when you copy the lot vertically.

Hope that makes some sense!

Phil