referencing excel ranges

J

Jesper

I'm using this to reference a cell in Excel:
objExcelDoc.Sheets(1).range("A1").Value = myvalue
how would this looks if I needed to use the R1C1 notation instead of A1?

Jesper
 
K

Klatuu

objExcelDoc.Sheets(1).Cells(1,1).Value = myvalue would be cell A1
objExcelDoc.Sheets(1).Cells(5,2).Value = myvalue would be cell B5
 
Top