|well it depends on how the macro is written, im assuming you have a loop that goes through each record and tries to copy paste until there are no more records? |
If so, what you could do is, say something like, if record is empty do nothing and move next, else if record is not empty copy paste. This will force the code to continue running if it encounters an emprty record.
It looks like what you are doing is, tell the code to read data regardless of if it is emprt or not and paste. This obviously will error out.
So handle it by doing the above. A snipet of the code will ne helpful, post it and let us see what we can do.