Wednesday, February 19, 2014

How to refer to a non-contiguous range in VBA? (VBA-Excel)

You just have to separate the continuous ranges by commas inside the range specifications, follow the example:

Range("A1:A10,C1:C10,E1:E10")

No comments: