Posted to microsoft.public.excel.programming

Neal Zimm

external usenet poster

Posts: 345

UsedRange and LastCell feb08

Hi -
Am learning about some new to me worksheet properties.
I know the first example below is a count, but shouldn't the row numbers
be the same in both examples? Why are they not?
Thanks,
Neal Z.

debug.Print activesheet.usedrange.rows.count
5499

debug.Print activesheet.usedrange.specialcells(xlCellTypeLastC ell).address
$CW$5498

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
lastcell	Danilo[_2_]	Excel Programming	2	January 19th 08 10:41 AM
LastCell	Howard	Excel Programming	5	March 6th 07 09:56 PM
Excel 2007 BUG UsedRange/LastCell differences with Excel2003.	keepITcool	Excel Discussion (Misc queries)	2	May 31st 06 06:18 PM
Dynamic LastCell	James Agostinho	Excel Programming	4	February 22nd 04 09:08 PM
LastCell Function	David	Excel Programming	6	December 5th 03 02:51 PM

All times are GMT +1. The time now is 07:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us