Hello. I want to be able to select any or all of the colors in rows A1-A7 and then run my compile macro and have the selected section appear in A10-A16. This performs as expected. Now, I want to make another selection and compile without clearing A10-A16. The only way this works is if I’m selecting the same number or more colors. If I select fewer then there are still some colors left over from the previous compile. I tried to “Clear Contents” of A10-A16 in the macro before pasting the new selection but when I do this it clears my new selected selection. Thanks

Attached Files

Book1.xlsm (18.6 KB, 10 views)