ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copying with a macro (https://www.excelbanter.com/excel-discussion-misc-queries/3731-copying-macro.html)

Markxxx

Copying with a macro
 
How do i Copy a chunk of data with a macro that may vary in size each time?

Norman Jones

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




All times are GMT +1. The time now is 08:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com