Hi team,

this is probably basic but :

when I have a formula in a cell it is then deemed as not blank for when I am
making refereneces to it or it's range, #n/a - #value etc are returned when i
want it to be treated as blank.

anyone throw some light on this please

thanks

steve