replace the letters (for collumn) & numbers(row no.) of cell reference only

A

al007

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to find/replace cells containing a number and letter 2
sorting using letters , but not alphabetically. 5
Select and copy only cells with values, open an app, paste into 2
Counting rows based on the contents of multiple cells 2
simple code but it doesn't look like usual vba code 2
How to Select A Cell in VBA with a Variable Row Number? 0
How to Select A Cell in VBA with a Variable Row Number? 3
Replace Column Letter only 0

Top