| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
replace the letters (for collumn) & numbers(row no.) of cell reference only
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace letters for numbers | Excel Discussion (Misc queries) | |||
| Converting text to cell reference and column letters to numbers -please help | Excel Worksheet Functions | |||
| coulmns with numbers instead of letters as the reference? | Excel Discussion (Misc queries) | |||
| How to change collumn heading numbers into letters? | Excel Discussion (Misc queries) | |||
| How can I make the collumn headers in excel be letters rather tha. | Excel Discussion (Misc queries) | |||
Hybrid Mode
