Changing formula in multiple cells or range simultaneously

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I am trying to change the value in multiple cells in a
large worksheet simultaneuously. I want to identify the
range and then adjust the formula in the entire range. Is
there a way that I can highlight the range and then change
to formula in each, simultaneously? For example, if I
wanted to double the value in the entire range, how would
I do this?

Thanks,

Michael
 
You could put 2 in an empty cell.
Copy it
Edit|Paste special|click on Multiply under the operation section.
Then clear out that 2.

But it really depends on what kind of change you're making. If you wanted to
add =abs() around your formula, I think you'll have to cycle through each cell.

Although if all the formulas are the same, you could do it with one assignment:

activesheet.range("a1:a99").formula = "=abs(sum(b1:e1))"
 
Back
Top