Cells: Referencing by Row and Column and Cell Position

[abktw2]

Hello-

I was hoping someone could explain to me the Cells property. I am teaching vba programing from a book to design a ss to work how we need it, but I am having trouble understanding this property. Specifically when using Cells(Rowindex, Columnindex) and Cells(CellPosition) and how it applies to Range.Rows.Count Any help on how to use these properties and why I would want to do so would be great. Thanks.

Adam

 

[MrKowz]

Cells(RowIndex,ColumnIndex) is another way to select a certain cell.

For example....

Cells(1,1) means Range("A1")

Cells(1,3) means Range("C1")

Cells(23,5) means Range("E25")

You can use the same arguments with cells as you can range... for example if you want to find the last row in a column with cells versus range...

Cells(rows.count,1).End(xlUp).Row

A big advantage to the Cells property is now you can find the last column in a given row!

Cells(1,columns.count).End(xlLeft).Column

 

[mgrzymala]

What would be the command to find the first column of the row?

Thanks