Posted to microsoft.public.excel.programming

Nigel[_27_] Nigel[_27_] is offline

external usenet poster

Posts: 25

find range size

so i have a range named Range("DRP")
that range is always changing, and i would like to know how many cells
wide and long it is..
for example....if currenty Range DRP is from A1:D5, i want to know that
it spans 5 columns and 4 rows.

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
Find and Replace size	Neil	Excel Discussion (Misc queries)	2	February 23rd 08 08:12 PM
Find Folder Size	vqthomf	Excel Programming	10	September 11th 06 01:26 PM
How to find avg for step size?	Omkar	Excel Worksheet Functions	7	June 17th 06 04:01 PM
Cannot Expand Named Range - when size of the Range exceeds	Snig	Excel Discussion (Misc queries)	1	July 7th 05 01:46 PM
How to find out the size of a variable-size array ?	Adrian[_7_]	Excel Programming	1	July 6th 04 09:12 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us