Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
currentregion property not working properly
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
currentregion property not working properly
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
currentregion property not working properly
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Yes No box no working properly | Excel Programming | |||
Top Property in Excel 2007 Not Working Properly | Excel Programming | |||
But not working properly | Excel Discussion (Misc queries) | |||
Bug in Excel 2000? (CurrentRegion property triggers events) | Excel Programming | |||
ActiveCell.CurrentRegion property | Excel Programming |