Debugging Macro to Copy over just Conditional Formatting

Hi,

I am working on a macro which copies data from multiple sheets, creates a new sheet and pastes it in the new sheet sequentially and then sorts the data based on a column called "Region". But, every time this macro is run the conditional formatting rules change their ranges and multiply. maybe I thought it's because of all the CF from the original sheets are getting added which is sort of messing up the ranges and multiplying the rules. So once the new sheet is ready, I strip it off of all the conditional formatting and then copy the CF from one of the sheets and paste it with paste special -> formats on the new sheet but it still isn't carrying over the CF.

I am using Excel 2010 and here is my code which only shows the part where the CF is stripped off, haven't included the pastespecial for formats to the new sheet, any help would be really appreciated:

Please Login or Register  to view this content.

Any Suggestions or help would be greatly appreciated.

Per forum rule #3 please put code tags around your code.

You can easily do this by editing your original post. Highlight all your code and select the # from the toolbar and click save changes.

Thanks.

Are you able to post a copy of the workbook with sensitive data removed?
I've read your code, but I have to see the problem, see the CF and test your code with your data to help you.

I used the wrong term. You should change the sensitive data. If it's a name change it to John Doe, Jane Doe etc, if there's an account number just make up a fictitious one. You don't need all the rows either. So if you have thousands of rows, just delete all but a few.

Originally Posted by aadilshakir

There is too much sensitive data in it, if I removed it- all that will be left would be a blank sheet. I know looking at the sheet would provide more clarity on the issue. If there another to go about it?