PC Review


Reply
Thread Tools Rate Thread

currentregion property not working properly

 
 
TomE
Guest
Posts: n/a
 
      31st Oct 2009
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 With Quote
 
 
 
 
Barb Reinhardt
Guest
Posts: n/a
 
      31st Oct 2009
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 With Quote
 
TomE
Guest
Posts: n/a
 
      31st Oct 2009
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Top Property in Excel 2007 Not Working Properly TGATOR Microsoft Excel Programming 0 24th Jul 2008 08:38 PM
CTRL-F (Find) quit working after 6-months of working properly =?Utf-8?B?YmNyZWVu?= Microsoft Access Form Coding 0 31st May 2006 08:55 PM
Re: Bug in Excel 2000? (CurrentRegion property triggers events) Jim Cone Microsoft Excel Programming 1 13th Sep 2005 02:22 AM
ActiveCell.CurrentRegion property Microsoft Forum Microsoft Excel Programming 4 11th Jan 2005 02:43 PM
asp.net panel's visible property not working properly Jeff Microsoft ASP .NET 0 3rd Mar 2004 04:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:53 AM.