Hi, I have the relatively simple code below to conduct a count of uniquely
identified records in excel spreadsheet:

count = 1
name = "simple_excel_export_table"
numrows = 19
For s = 2 To numrows
With Worksheets(name)
cellb = .Cells(s, 1).Value
cella = .Cells(s + 1, 1).Value
If cella cellb Then
count = count + 1
End If
End With
Next s

For example, this code on the following spreadsheet would result in a count
of 4 (there are many more columns in my spreadsheet, this is just a sample):

ID UserSiteID
1 61051
1 61051
1 61051
1 61051
1 61051
2 61050
2 61050
2 61050
3 61048
3 61048
3 61048
3 61048
3 61048
4 61043
4 61043
4 61043
4 61043
4 61043
4 61043

however, this code is to be run on multiple sheets with different amounts of
records from sheet to sheet. How can I enhance the code to assign the proper
number of records, or rows, to the "numrows" variable for each spreadsheet,
without having to manually go change the number assigned to "numrows" each
time? Or is there a better way to do this?? any help appreciated