Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to replace file name in linking formula
In column B I have a linking formula to a specific file. In column A I have
about 200 rows with different file names in each row. I would like to replace the file name in the linking formula in column B with the file name in Column A so that then the resulting linking formula in column B would link to the file name listed in column A. I have the following macro but it only replaces the first row. I would appreciate help to change the macro so it continues down column B until it reached a blank cell. Dim NameOld Dim NameNew Dim row Sub NameReplace() Range("B6").Select For row = 6 To 600 NameOld = Cells(4, 1) NameNew = Cells(row, 1) Selection.Replace What:=NameOld, Replacement:=NameNew, LookAt:=xlPart _ , SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False If Cells(row + 1, 1) = "" Then Exit Sub Next row End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro that adds formula to replace text | Excel Worksheet Functions | |||
Macro to replace file name many times | Excel Programming | |||
Macro to evaluate a cell and replace one part of the formula | Excel Programming | |||
How can I replace a formula with its result using a macro? | Excel Programming | |||
macro to export files but not replace an exsisting file name | Excel Programming |