尝试复制和粘贴一些可变数据。

i'm working on a existing excel file with lots of macros and want to copy and paste variable data from 5 different sheets to 5 other sheets without copying blank cells. this is what i made so far and gives me Runtime error 1004:i'm working on a existing excel file with lots