I have a fixed range of cells, F6:L59. I need to be able to select all cells in the even rows only (6 to 58), but only from columns F to L.

I would like to make a cleaner macro other than F6...select, G6....select, H6....select, etc.

Once all cells are selected, I would then run clearcontents. I can't select more than one cell at a time, otherwise i get an error message due to another piece of code that runs down the columns of the same range.

Thank you!