Aha! [VBA]...
rngDestination.Value = x
Call rngDestination.Replace("#N/A", "")
...[/VBA]

Not sure if this is the cleanest way to solve the problem, but it works for now! If there's a better way, I'd be interested in any other suggestions.

Thanks for your help.