Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sub testrow()
Dim c As Range, i As Integer 'I INTEGER??? Dim ReplaceFrom As String Dim ReplaceTo As String ReplaceFrom = InputBox("Letter to be replaced - Same case") ReplaceTo = InputBox("Letter to be replaced to- Same case:") For Each c In Selection.SpecialCells(xlCellTypeFormulas) With c For i = A To Z ???????? .Formula = Replace(.Formula, i & ReplaceFrom, i & ReplaceTo) Next i .Formula = Replace(.Formula, ReplaceFrom & "$", ReplaceTo & "$") .Formula = Replace(.Formula, "(" & ReplaceFrom, "(" & ReplaceTo) End With Next c End Sub CAN ANYBODY CORRECT THIS MACRO OR GIVE ME THE CODE WHICH WOULD LOOP FROM A-Z (ReplaceFrom & ReplaceTo being row numbers) Thxs |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I turn excel columns from column number to column letter? | Setting up and Configuration of Excel | |||
How to replace column letter in refferences with a function using the old column letter? | Links and Linking in Excel | |||
How to replace column letter in refferences with a function using the old column letter? | Excel Worksheet Functions | |||
Column letter | Excel Programming | |||
column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) |