Zero a column

[Bill_Biggs]

I need a macro that will fill in several cells in a column with zeroes but not all of them. Is there a quick one that would zero out say A1-A5, A7-A12, A13-A18. I assume that I can enter these in a range, but my range macros are limited. Is this simple enough that some one could help me?

 

[dsaffo]

Hi Bill,
Do you have any other information in the line that will signify that it should be a zero. For example, if B2 is empty, then zero out A2?

 

[RoryA]

Range("A1:A5,A7:A12,A13:A18").Value = 0

should do it.

 

[Richard Schollar]

Hi Bill

range("A1:A5,A7:A18").Value = 0

would do that. Have I misunderstood your requirement?

 

[Bill_Biggs]

No, I am just zeroing out a report at the beginning of each week and it would be cool to zero out the column with a single click.

 

[Bill_Biggs]

Wow, that is simple, thanks all!