Posted to microsoft.public.excel.programming

Jamie Martin[_2_] Jamie Martin[_2_] is offline

external usenet poster

Posts: 25

finding last row number of UsedRange

I want to loop through all the rows in my active worksheet's UsedRange. How
can I extract from the UsedRange Range object the numbers of the last row
and column?

Thanks everyone so much for your help--I really appreciate this community.

Jamie

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
Why is worksheet.usedrange empty?	Sara	Excel Worksheet Functions	2	August 24th 07 03:38 PM
Real Value of .UsedRange.Rows.Count	dazman	Excel Worksheet Functions	2	August 25th 05 03:24 PM
UsedRange problem	Andy	Excel Programming	2	September 18th 03 05:17 PM
Find Usedrange question	Stuart[_5_]	Excel Programming	2	August 31st 03 06:39 PM
Usedrange	Terry VanDuzee	Excel Programming	6	August 10th 03 05:57 PM

All times are GMT +1. The time now is 02:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us