If your headers are in rows 1:12

with worksheets("sheet1")
.range("13:" & .rows.count).clearcontents
end with

But do you have stuff you have to keep in (say) column A?



DOOGIE wrote:

I am trying to set up a macro to clear the data from all the cells on a
worksheet without clearing the column headings on the worksheet. How do I
accomplish this?

--

Dave Peterson