I have a cell (B16) which has its content placed into it by the following macro:
Code:
If xferArray(14) <> 0 Then Cells(16, 2).Value = xferArray(14)
Else: Cells(20, 2).Value = ""
End If
However, in some instances I may wish to override it, so my cell has the code:
Code:
=IF(Inv_override,"",B16)
As with many of my bright ideas, it doesn't work.
Im guessing that a small adjustment to my code will do the trick, but what? Can someone help?