Set multiple range

[myownworld]

Hello, so I'm trying to set multiple cell ranges and here's what I've done.
It works okay but there's a problem, I noticed that the selection on r1 and r2 are right, but when it selects from r3 to r5 it also selects columns S and T and I don't need it to select S and T. How do I fix this?

Please Login or Register  to view this content.

[tigeravatar]

myownworld,

The problem is that you want the entire range to be enclosed in the quotes, not split up like you have it:

Please Login or Register  to view this content.

Alternatively, you could just do the following:

Please Login or Register  to view this content.

[myownworld]

Oh cool, it worked. Thanks! :D