Because you usedrange has multiple columns.

count is #rows x #columns

--
Regards,
Tom Ogilvy


"HotRod" wrote in message
...
Why in the following example do I get two differnet answers. Whats the
difference between the two?


Set Rng = Worksheets("Main Sheet").UsedRange.Rows
Main_Sheet_Count = Worksheets("Main Sheet").UsedRange.Count

Debug.Print Main_Sheet_Count = 7692

Debug.Print Rng.Rows.Count = 641