Hallo,
was steht denn in R1 und R2 ?
Aus einem alten Artikel:
To
access a Range object in Excel, simply specify the Range with which you want to work: Range := Sheet.Range['C1:F25']; In this case the code defines a range from cell C1 to cell F25.
Also müsste das doch so sein
statt
Range := Sheet.Range[R1, R2];
so sein
Range := Sheet.Range[R1+':'+R2];