Change Linked Formula Column to Next Column Through VBA

[ayyappan80]

Hi

I have formula linked in some excel workbook on Various Columns, i want to select those columns and want to change the next column of Formula through VBA.

Like the below Formula linked with Column AC i want to change as "AD"

C:\[Hello.xlsx]Test'!$AC$89*1000

the below Formula linked with Column BC i want to change as "BD"

C:\[Hello.xlsx]Test'!$BC$91*1000

the below Formula linked with Column K i want to change as "L"

C:\[Hello.xlsx]Test'!$K$915*1000

Like this for selected columns. Please help

[zzzeddy]

Hi

You don't need to use vba to adjust your link formulas.
1. Open the file with the link-formulas you want to adjust.
2. open the file [Hello.xlsx]
3. Switch to view the file [Hello.xlsx], and move to the sheet named Test
4. Move the cellpointer to cell [A1] and Insert a new column
5. Switch view to your file with the link formulas.
6. You will see that the links have now been updated, so now save the file with these new updated link formulas.
7. Now Close the file
8. Close the [Hello.xlsx] file without saving (i.e. ignore the change you made when inserting the new column)

zeddy

[ayyappan80]

Hi zzzeddy I consider your suggestion . But i have 4 to five workbook so expecting help from VBA code