Getting the cell reference - last cell with text

D

DuncanG

How can I automatically/ continously get the cell reference to the last
cell in a particular column, that contains text? Any help would be
appreciated!

*Thanks. :) *
 
N

Nick Hodge

Duncan

How are you trying to do this as you are in the misc group?

Programmatically...

LastRowInA = Range("A65536").End(xlUp).Row

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top