Range vs Ranges in vba

[lezawang]

Hi
What is the difference between them? Not sure why we have 2. I noticed there are many things like that SortField SortFields and OpenFile vs OpenFiles.

Thank you.

 

[Rick Rothstein]

I was not aware Ranges existed (never saw or used it before); however, the Help Files says Ranges is a Collection and it Range objects as it members. I'm not sure I see any practical uses for a Ranges collection as specifying a non-contiguous range directly or creating a Union, both of with come with a rich set of properties and methods, would seem like a more useful way to go.