I need to look at every cell in the sheet and if it has "#N/A" then I need to
replace it with "" . I know of a long way to do it (looping through each
cell in each column), but I wanted to see if anyone new of a shorter way to
just look through the whole sheet. So far I have this... and I would do this
for each column. I'm using Visual Studio rather than VBA but its similar.
Thanks!

For i = 1 To lastRow

If oApp.Range("B1:B" & lastRow).Value = "#N/A" Then
oApp.Range("B" & i).Value = ""
End If
Next