I’m currently using the Worksheet.Cells[row, column] indexer. Are the indexers 0 or 1 based? Can I use named ranges or alphanumeric values for the indexer? Right now the search isn’t working so I’m unable to check.
Recently purchased.
Thanks
Karega
Hi,
Yes, indexer is 0 based and also you can use cell name to access a cell.
e.g
Cell a1=worskheet.Cells[“A1”];
But you cannot use it for ranges, for that there is a different method.
i.e
Worksheets.GetRangeByName