On Error Resume Next
selection.specialcells(xlblanks).value = 0
On Error goto 0

--
Regards,
Tom Ogilvy


"Paul" wrote:

using VBA is it possible to select a range of cells (e2:g3 - some may contain
numeric value (no text)), then put a zero into any of the cells that do not
contain a numeric value.

help appreciated