Extending the number of reference cells passed to .Range function in Excel VBA

I am开发者_如何学Python using worksheet.range("Relevantcells") to copy cells in a sheet. I have non-contiguous cells and hence it only lets me put in 60 specific cells.

How can I extend this to many more cells that I want to read from?

---

Instead of having one large non-contiguous range, you could create an array of smaller ranges in code and then copy each range iteratively.

You'll likely take a performance hit over copying the ranges en masse, but this approach should be more flexible.