apply formula to each cell in range - relative references

I've managed to do what I set out to, which is to put a relative formula in each of the cells in a range in a table using the following section of code:

Please Login or Register  to view this content.

However, as some of the cell values being returned are blank, I get #N/A returned.

If I change to the following

Please Login or Register  to view this content.

the formulas stop being put in any of the cells in the range.

Putting the iferror formula into each cell manually works though.

Anybody know why cos it's killing me

Maybe add an if statement?

Please Login or Register  to view this content.

Yup, that does the trick.

I suppose I could remove the iferror part of the formula (as it's ignored) and just use your line to hide the inevitable error.

Another 'quirk' to add to the list.

Cheers.

Glad to hear it works for you.