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.

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" wrote:

> 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.

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.

"Barb Reinhardt" wrote:

> 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" wrote:
>
> > 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.