Hi guys,

I have the following code which I'm using to find the last 10 rows that have something in them, and then copy the data into a summary table. The code works fine. The only problem is when the data gets pasted into the summary table, for some reason Excel is applying conditional formatting to some of the cells in the summary table. I have no idea why because the cells that I'm copying from don't have conditional formatting in them (although some others on the worksheet do).

Does anyone know why this is happening? I've noticed the same thing on some other macros that I've written and used to move data around my spreadsheets. I don't know if it's the code I've written or something else with Excel in general?

Please Login or Register  to view this content.
Cheers,

Chris