Macros-editing worksheet without editing macro

I would like to create a macro that rolls the current year data to the prior year column on a two year financial statement and zeroes out the current year column. We add and delete rows constantly on the statments. My question is: Is there a way that I can zero out a range of cells in a macro that will let me add and delete rows in the worksheet and automatically modify the macro to zero out the new range?