Delete the row or Clear the row? Very different results

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"ChuckF" wrote in message
oups.com...
I have a spreadsheet where we have collected data for the entire year.
Every other row needs to be cleared out. I need a way to be able to
clear the data from these cells automatically. Can anyone come up with
a macro for this.

This is what I have This is what I
want
1
1
2
3
3
4
5
5
6
7
7
8
9
9