starguy wrote:
thanks again for explaining. Infact when cell reference is different
then it would be tidy to change it in formula on frequent basis.

But then you either paste it in with the corrct offset or use Find & Replace