ExcelBanter - Change fomula in multiple cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Change fomula in multiple cells (https://www.excelbanter.com/excel-programming/447972-change-fomula-multiple-cells.html)

JBrown

Change fomula in multiple cells

Excel 2010, How to change the fomula in multiple cells at once. The fomula will be the same.

JBrown

Quote:

Originally Posted by JBrown (Post 1608550)

Excel 2010, How to change the fomula in multiple cells at once. The fomula will be the same.

I figured it out. Ctrl F and use replace option.

witek

Change fomula in multiple cells

JBrown wrote:
Excel 2010, How to change the fomula in multiple cells at once. The
fomula will be the same.

Range ("a1:c10").formula = "=b15+1"

All times are GMT +1. The time now is 07:34 PM.