0's to blank cells
 

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

0's to blank cells
 

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

0's to blank cells
 

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

0's to blank cells
 

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