Tag Archives: column

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.  

Convert kolom letter naar kolom nummer

If you have a column letter and want to turn it into a number, you can use the followingapproach: numberColumn = Worksheets(1).Columns(AlphaColumn).Column numberColumn = Sheets(“Blad1”).Columns(“J”).Column  Result = 10