It would help if we could see what you have. Maybe a do.. loop through some
named ranges would do the trick?

"Harlan" wrote:

I'm trying to write a macro that will select a certain range of cells. The
problem is, new rows will be added to and subtracted from the worksheet. But
i still want to be able to have this macro select a certain range, all in one
column and then clear the contents of that range.
Also, I have cells throughout the sheet that are grouped and span the length
of the sheet. These cells have text in them, and that text is constant, will
not change and are group headings.
I'm guessing I have to have the macro select the cells in the specified row
between two constants, then clear the contents and then go on to the next
section. I'm just not completely sure how to do that.
I'm new to VBA and have some VB experience. I understand some of the
constants.
Thanks
I hope I'm not asking too much.