Just a thought, are you placing your active cell closer to the edge of
the sheet then what your macro was originally recorded as copying or
pasting,
Another thought, if you are copying the same range to many sheets; you
could group all your sheets together and then work on one sheet to
change all the sheets grouped.
Click on the sheet tab press Ctrl and click on the sheets you want to
group once grouped you only have to work on one sheet , when finished,
just click on any of the grouped sheet tabs and the sheets will ungroup
Dave