currentregion property not working properly

  • Thread starter Thread starter TomE
  • Start date Start date
T

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.
 
If there are no used cells immediately adjacent to A1, you won't get anything
else int he current region. Have you tried UsedRange?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CurrentRegion - Usual Behavior? 2
Count Rows Bug??? 3
Resize CurrentRegion by 2 rows at the bottom 6
OFFSET LOOKUP function in VBA? 9
CurrentRegion works different in the Editor than in the workbook 2
extend selected CurrentRegion results in application or objectdefined error 1004 4
Compare two worksheets in the same workbook and highlight difference 7
Error in vba module 1

Back
Top