Using Column Letters to Reference Cells

The function Cells(row number, column number ) can also take column letters! For example

Dim X

X = Cells(1,”C”).Value

will return the value of cell “C1”.

With this approach, you do not need to get the column number to refer to a cell.

 

1 reactie