Markxxx" wrote in message
... How do i Copy a
chunk of data with a macro that may vary in size each time?


Hi Mark,

You would need to provide some details about the variable chunk, but
possibly::

rng = Range("A1").CurrentRegion

---
Regards,
Norman