How To Refer To A Range Of Non-Contiguous Cells as in example

[thecdnmole]

With only being able to have two arguments when using the "Range" property, how would be the best way to handle this?
I am thinking break it apart into five separate lines?

Please Login or Register  to view this content.

[Fluff13]

What makes you think that won't work?
It works for me.

[thecdnmole]

From what I've been reading about the Range property, but yes, it does seem to work, which has me puzzled.

[Fluff13]

There's certainly nothing wrong with using a range in that way, so not sure what you have seen

[thecdnmole]

This website for example, http://excelmatters.com/referring-to-ranges-in-vba/ and on another webpage, https://docs.microsoft.com/en-us/pre...6(v=office.11) they showed this as an example, Range.PNG. But great news that this is ok and I don't have to change anything. Wonder where does this rule come into play where you can only have two arguments?

[Fluff13]

Ok, I understand.
In your code whilst you are using a number of different addresses, as they are all included inside the same set of quotes it is only 1 argument.
using 2 arguments would be like

Please Login or Register  to view this content.

[thecdnmole]

Ok, thanks Fluff13.

[Fluff13]

You're welcome & thanks for the feedback