Referencing Any Cell in a Column

[L.A. Lawyer]

How do I reference any cell in column or, more precisely, any cell in a
column after the title row?

 

[kkknie]

Not sure what you're after...

To reference a cell in a column (say A), you could use:

Range("A" & i)

where i is a value from 1-35536

Or,

Cells(i, 1)

with the same i condition. I am sure there are others as well.
Clarify what you are trying to do and I'll try to give mor
information.

 

[L.A. Lawyer]

I am trying to refer to all of the cells in the column except for the title
row. I suspect that the number of rows will be growing over time, too.

 

[Tom Ogilvy]

One possibility:

Dim rng as Range
With Worksheets("Sheet1")
set rng = .Range(.Cells(2,"E"),.Cells(2,"E").End(xldown))
End with
msgbox rng.Address

--
Regards,
Tom Ogilvy

I am trying to refer to all of the cells in the column except for the title
row. I suspect that the number of rows will be growing over time, too.