Hi,
i'm need combine several Ranges in one Range. So, code in VBA is working:
Code:
sAddress = "A4:R9,A11:R436,A439:R452,A454:R1326"
Set oRanges = Application.Range(sAddress)
all ok.

And, when i'm trying running code like this, the VB6.0 IDE generate error. My code is:
Code:
sAddress = "A4:R9,A11:R436,A439:R452,A454:R1326"
Set oRanges = oExcel.Range(sAddress)
If I write by one Range
Code:
sAddress = "A4:R9" 'or for example "A11:R436"
Set oRanges = oExcel.Range(sAddress)
all work.

Is it possible use anyway non-continues Ranges?