What Are The Limits When Creating A Range With VBA

I have a text string concatenated from an array of about 3,500 elements. The concatenation looks something like the following:

sRange = "$A$3,$A$7,$A$8,$A$13, ..."

When I try to set a range with the said string: MyRange = Range(sRange), the system throws an error.

I've seen a few methods in help ("Union" for one) that accept up to 30 arguments. I'm unable to find anything in help that states a limit for MyRange = Range(). It appears that 30 may be the magic number for everything.

I have tried using "Union" and building the range one element at a time from the array. That works, but it's incredibly slow.

Is there any way I can pass my array as the argument directly? Something like: MyRange = Range (MyArray).