move a group of arguments in a cell formula

[Sconehead]

Hello.

I have a column with equations in. These equations are all variations of the same one. The difference is that the arguments in the equation change for each row, and there isn't a pattern to how they change. Is it possible to quickly move the arguments in the formula, instead of doing them one at a time?

The formula in row 4 looks like this:

=INTERP(K4,F4,F5,G4,G5)

whereas the formula in row 16 may look like this:

=INTERP(K16,F29,F30,G29,G30)

As I have 70 rows of data, I don't want to go through each one and have to move 4 individual cell references. The Fcells and Gcells will always follow the same pattern relative to themselves, but not relative to the Kcell.

 

[wideboydixon]

I'm not clear on [1] what the equations look like now [2] what you want them to look like. If it currently has:

=INTERP(K4,F4,F5,G4,G5)

What do you want to change it to?

WBD

 

[Sconehead]

I want to keep the structure of the function the same, but change the 4 arguments on the right hand side. Is it possible to move them as a group?

 

[wideboydixon]

Yes. You can use VBA to change the .Formula property of the cell or range but you're not giving any indication what you want to do.

WBD