Posted to microsoft.public.excel.programming

TomE

external usenet poster

Posts: 2

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Yes No box no working properly	Miree	Excel Programming	2	October 15th 08 08:14 AM
Top Property in Excel 2007 Not Working Properly	TGATOR	Excel Programming	0	July 24th 08 08:38 PM
But not working properly	Rao Ratan Singh	Excel Discussion (Misc queries)	2	September 14th 06 08:45 AM
Bug in Excel 2000? (CurrentRegion property triggers events)	John Coleman	Excel Programming	3	September 13th 05 02:22 AM
ActiveCell.CurrentRegion property	Microsoft Forum	Excel Programming	4	January 11th 05 02:43 PM

All times are GMT +1. The time now is 12:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us