I looking for a macro which would replace the letters (for collumn) &
numbers(row no.) of cell reference only of a selection containing
formula:
e.g (for letters) if a cell contains
= Sheet1!s2+sum($s100:$ss100)

replacing s for tgives t100 & tt100 only

same for numbers - row numbers only changing & not numbers forming part
of a sheetname
can anybody help with this macro
thxs