Last cell in column .

How do I find the last used cell in a column?
Each day a new cell is used in the column so the column gets longer.I want to use the info that is contained in the last used cell.

[Dave Hawley]

Try

Range("A65536").End (xlUp)

[karraj]

counta(A:A)

[Mark W.]

On 2002-03-09 01:41, Anonymous wrote:
How do I find the last used cell in a column?
Each day a new cell is used in the column so the column gets longer.I want to use the info that is contained in the last used cell.

Does the column contain numeric or text data?

[Mark W.]

On 2002-03-11 15:28, karraj wrote:
counta(A:A)

=COUNTA(A:A) will not count empty cells so cannot be used alone if empty cells are dispersed among the cells that contain values.

[karraj]

that is true...

[Juan Pablo González]

=COUNTIF(A:A,"<>""")

will return the last used cell on that sheet, BUT, THIS IS NOT RELIABLE. So, go with Dave's solution, VBA is the only "reliable" way of knowing.

[Mark W.]

...VBA is the only "reliable" way of knowing.

Ouch! If feel a pain in my chest!

=INDEX(A:A,MATCH(9.99999999999999E+307,A:A)

...works quite nicely for numeric data. My inquiry as to the nature of the data has yet to be answered.

[ This Message was edited by: Mark W. on 2002-03-11 16:29 ]

[Juan Pablo González]

I know Mark... Match works GREAT for numeric data, but, we've seen more than once that THAT column doesn't have numbers...

Oh, anyway...

[Mark W.]

On 2002-03-11 16:31, Juan Pablo G. wrote:
I know Mark... Match works GREAT for numeric data, but, we've seen more than once that THAT column doesn't have numbers...

Oh, anyway...

I didn't have the chance to respond last night... had to join by buddies for some billiards.

Consider this for determining the extent of a column of typical text values...

=MATCH(REPT("z",255),A:A)

This can be refined if a key field of a data list is fixed length (or its maximum length is known) such as an account number. So for an 8-character account number you'd use....

=MATCH(REPT("z",8),A:A)