Macro

S

Suet

Hi - I am using Excel 2003. I have a column that I enter
#'s into everyday.
Mold 559 2
3
0 etc.

Mold 2
0
5 etc.

Sometimes there are no #'s to enter next to the specific
catefogy (Mold) and then I have to enter just 0's. I
would like to set up a macro so I can activate a button on
my toolbar and have just 0's fill in the cells. I have
tried to set up a column of the correct # of 0's and then
do a macro just to paste, but the syntax is wrong. Can
anyone help. Thank You
 
J

jeff

Hi,

I'm not sure I understand what you want, but this
code puts in zeros in E3:E10 and F3:F7

Sub DoZeros()
Range("E3:E10").Value = 0
Range("F3:F7").Value = 0
End Sub

jeff
 
S

suet

Hi Sorry I wasn't clearer. As you can see from my
example there are different sections in the column
(Mold). However, every section has the same number of
cells (categories for the numbers) so I need a macro that
will just put 0's in say 12 cells next to each section.

Thank You
 
Top