开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜