Need Help to run a macro when I copy certain rows eg A36:49 that have conditional formatting in them, macro asks which position (row) eg A19 to insert in and then clear contents of cells where they have come from.

test.xlsm

http://www.mrexcel.com/forum/showthr...93#post3154193