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