Posted to microsoft.public.excel.programming

Buffyslay

external usenet poster

Posts: 40

ActiveSheet.UsedRange.Rows.Count = 5002? why?

hi there

my code ActiveSheet.UsedRange.Rows.Count gives 5002, but i am only
using 1 (cannot set to one as in future this will be dynamic...)

any ideas?

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
selecting ActiveSheet.UsedRange	Gary''s Student	Excel Programming	5	May 12th 06 04:29 PM
Problem with USEDRANGE.ROWS.COUNT reporting one row too many	Peter Rooney	Excel Programming	9	January 18th 06 03:51 PM
how to reset the activesheet usedrange value	Gary Keramidas[_4_]	Excel Programming	5	September 28th 05 03:08 PM
Real Value of .UsedRange.Rows.Count	dazman	Excel Worksheet Functions	2	August 25th 05 03:24 PM
Problem with UsedRange.Rows.Count	alainB[_15_]	Excel Programming	4	April 29th 04 10:29 PM

All times are GMT +1. The time now is 05:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us