Solved: Setting Cell Value = #N/A

[ajrob]

Actually, I want to set the variable BkgTot = #n/a when one of the three columns is empty. In my code, can I substitute:

BkgTot = CVErr(xlErrNA)
for
BkgTot = 0