0's to blank cells

[Paul]

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

[Tom Ogilvy]

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

[Paul]

worked treat, many thanks

Paul

"Tom Ogilvy" wrote:

> 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

[Tom Ogilvy]

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