Rows and Column of Excel File

Question

It is possible to write a code that specifying the rows and column of spread sheet in terms of NUMBERS and NOT LIKE (B2:D6)

Example:

excelSheet.Range("B2:D6").Interior.Color = RGB(100, 100, 255)

instead of B2 and D6 I want to write 5 rows and 3 column..

It is posible to write in vb.net 2003 code?

Answer 1

This is C# and not VB, but this shouldn't be too hard to convert:

var firstCell = (Excel.Range)sheet.Cells[3, 3];
var secondCell = (Excel.Range)sheet.Cells[5, 7];
var cells = sheet.get_Range(firstCell, secondCell);

Answer 2

Just use Cells() instead of Range()

excelSheet.Cells(5,3).Interior.Color = RGB(100, 100, 255)