Copy Excel data with all colors and all format

Hi @Charu_Rathi, It worked then. Thanks for your help! However i have another prob. i am using “format painter” directly clicking on it at excel then after it sometimes pop up something in excel saying that “i am copying large size…” Just like that. What i want to do is that when this pop up appears, i just need to close it or click cancel button in it to proceed to another activity but when i do nothing happens. What can i do? any suggestion? Appreciate your help.

Here is the pop up message appreared when i click format painter.

Thanks