View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
anonymous anonymous is offline
external usenet poster
 
Posts: 1
Default Macro to Count Rows

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