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