Excel - Cell Addressing (Address and Indexing)

Card Puncher Data Processing

About

Although you could use Visual Basic string functions to alter A1-style references, it's much easier (and much better programming practice) to use the Excel - Cell(1, 1) notation.

Column Number

ActiveCell.Column

From Letter to Number

colNumber = Range(colLetters & "1").Column





Discover More
Card Puncher Data Processing
Excel VBA - Range

Range represents: a cell, a row, a column, a selection|selection of cells containing one or more contiguous blocks of cells, or a 3-D range. Range property: If you use a text argument...



Share this page:
Follow us:
Task Runner