How to Add a formula to all cells

[tonylyx]

Hi everyone,

I have a massive database that I need to add the "IFERROR" Formula to.

I thought about doing a search and replace "=" with "=Iferror(", but this doesn't solve the problem of the end part of the formula where I have to add in ",N/A)"

I was wondering if there is a way to add in a formula to all cells?

Thank you.
Tony

[zbor]

Write in first cell formula you want and if they are in contiguos row when you double click black cross at the right bottom corner of the cell it should apply to all other cells.

[tonylyx]

Hi zbor, but that would override all the other existing formulas within the other cells as well. The other cells contain indirect function etc..

[jeffreybrown]

Maybe you can use a macro...

Here is some sample code that will is convert all formulas in cells A1:A10...

Please Login or Register  to view this content.

[tonylyx]

Thank you Jeff it works! Starred