How to add INDIRECT to all formulas

Try this

Please Login or Register  to view this content.

Thanks! That was much more efficient that what I was doing. I found some similar code to help me add the quotes and parentheses at the end but this worked all in one step!

Now I'm trying to tackle a similar but slightly more complicate issue. I have INDIRECT in all my formulas, as needed, so now they look like this...

=INDIRECT("Table1a!N4")

I'd like to change all formulas in several columns so that the cells appear blank if the value in Column F (of that same row) equals 0. If values are 0 in column F, then the metrics I've included in the other columns don't apply, so I'd like the cells to be empty, rather than 0, so they are not interpreted as meaningful. So, I'd like the data set to look like this:

Column F, Column G, Column H
10, 8 , 9
15, 10, 14
0
10, 9, 7
0
20, 15, 17

So if the formula shown above was in Column H Row 3, I would want it to change to the following...

=IF(F3=0,"",INDIRECT("Table1a!N4"))

Is there some way I can alter the code you provided above to make this work? I tried messing with it myself but I was only able to get the extra close parentheses at the end. I'm new to VBA so this is probably well beyond my current skill level.

Thank you again for your time and assistance!