Hi Bruno, try this:

ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row

Mike F
"anonymous" wrote in message
...
Hi, I'm hoping some of you Excel Guru's can enlighten me.
Here's what I'm trying to do:

I have a sheet open and I paste a column of values in.
I don't know how many rows are in the list since it will change every time
I
want to run this process.
I'd like to hit a macro key and get a count of the number of rows in
column
1.

Is there a way to do this?

Thanks for any help!
Bruno