Insert 0 into specific column and specific rows

Hello,

I am looking for a macro that I can insert into a button that will insert a 0 into specified rows in a column. For example, I want rows 1-10, 3-20, 4-60 in column D to have a 0 inserted into those cells. Can anyone help with this? Thanks!

Isn't rows 1-10, 3-20, and 4-60 in column D the same as rows 1-60 in column D?

Please Login or Register  to view this content.

I should have paid more attention when I was asking my question. I have some titles in between so for example it would be more like 1-10, 15-25, 30-40. See what I mean? Would I just put multiple "Range" functions that include the rows I need? Thanks!

Would I just put multiple "Range" functions that include the rows I need?

In your specific situation that would probably be best.

Please Login or Register  to view this content.

This is, of course, assuming that you don't need to test those ranges for a present value