A Macro so it does not copy all rows.

[Roco]

Sorry for posting under Formulas & Functions, but the link for macros was not working.

Here is my question and what I would like to do. I want to tweak my "Copy Rows" button, so it does not copy rows that are "Shaded". My Shaded items will alway fall between "General Conditions and "SubTotal General Conditions". Also Shaded items will fall between "Surveying and SubTotal Surveying".

Sometimes I will have more or less items that are shaded, and they will not alway fall in the same rows, but will always fall between what I have stated above. Can this be done? If so I would really appreciate the help in adding to the marco. Please see attached.

[dflak]

We need one more piece of information before attacking this problem - turn on the macro recorder and shade as cell exactly like the cells you do not want copied and then turn it off. Post the macro. We need to know the exact format for what we are looking for. I assume you do want to copy the rows with the pale yellow shading.

[Roco]

Thank you for your reply. Please see attached. I would like to copy all rows accept for the ones that are in the shaded area. They will not always fall in the same row area. I want to tweak my "Copy Rows" button, so it does not copy rows that are "Shaded". My Shaded items will alway fall between "General Conditions and "SubTotal General Conditions". Also Shaded items will fall between "Surveying and SubTotal Surveying".

Sometimes I will have more or less items that are shaded, and they will not alway fall in the same rows, but will always fall between what I have stated above. Can this be done? If so I would really appreciate the help in adding to the marco. Please see attached.

[dflak]

This is a bit easier to work with. The cell is either shaded or not. There are no other kinds of shaded cells.

[Roco]

Thanks for responding dflak....but it is not what I'm looking for. I just want to copy all the rows that are not shaded. The shaded rows will still have to stay in the rows that they are in...just as a reference to refer back to. The copied rows will not be pasted any place in excel. I will paste this information into my estimating software.