Here's hoping you can help a very new person to VB.
I've got an Excel file with links to other Excel files in hundreds of cells, but there are two parts of these links in each cell I want to change automatically with this VB below
I used the following (the file replaces the first one correctly..but
Expand|Select|Wrap|Line Numbers
- Sheets("Dry Year Final Balance").Select
- Range("B1: AG110 ").Select
- Selection.Replace What:="date", Replacement:=baseyear, LookAt:=xlPart, _
- SearchOrder:=xlByRows, MatchCase:=False
- Sheets("Dry Year Final Balance").Select
- Range("B1: AG110 ").Select
- Selection.Replace What:="Dummy", Replacement:=NewRunNo, LookAt:=xlPart, _
- SearchOrder:=xlByRows, MatchCase:=False
I tried using UpdateLink:=0 after the 1st replace, but this didn't work or I placed it incorrectly
Apologies if this is very basic, but I am tres new to VB.
Look forward to your answers.
M