cell references
Another way is to highlight the cells with formulae in and do CTRL-H
(Find & Replace):
Find What?: a15
Replace With: a17
then click Replace All. You can repeat this for other formulae which
might have different cell references.
Hope this helps.
Pete
|