Function for counting number of rows

[blakemckenna]

Is there a function that will count the number of rows that contain data for a specified range? I can't find one. The "count" function only counts when there are numeric values. I just want a count of rows with data in general.

Also, I have a worksheet with a list of names and some other data. I also have a form where I am inputing data. I wish to append this data to the end of my sheet or where the last row of data is when I click on a Command Button. How can I do this programmatically within VBA in my "Commandbutton1_Click" event?

Thanks,

Blake

[si_the_geek]

There are several Count functions, the one you need here is CountA (I'm not sure why it's called A!)

[blakemckenna]

Thanks geek...that's what I was looking for.