currentregion property not working properly

[TomE]

I have a worksheet with 3 columns and 202 rows that I need to sort. The sort
method didn't work and I also found that the command:
Range("A1").currentregion.rows.count returns the value of 1 instead of 202.
Strangely enough, if I copy the worksheet into a new workbook it works. Any
help with this would be appreciated.

 

[Barb Reinhardt]

If there are no used cells immediately adjacent to A1, you won't get anything
else int he current region. Have you tried UsedRange?

 

[TomE]

There are no blank cell in the range from A1:C202. All integer numbers. My
main problem is not the failure of the currentregion property but that the
range doesn't sort.