Posted to microsoft.public.excel.programming

Tom Kreutz Tom Kreutz is offline

external usenet poster

Posts: 15

Determining the size of an input array

Dear Folks,

In Visual Basic, how does one determine the size of an array (range?)
being passed in from Excel? For example, if I wanted to write my own
version of SUM(), how would I know the size/length of the range that the
user has chosen?

Many thanks,

Tom Kreutz

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
Determining whether dynamic array has been used	MDW	Excel Programming	2	May 9th 06 02:45 AM
Determining File Size	davidm	Excel Programming	3	October 19th 05 07:34 AM
Determining number of values in an array (2 related questions)	KR	Excel Programming	3	March 4th 05 09:33 PM
Determining Array Limit	Chaplain Doug	Excel Programming	3	January 5th 05 01:37 AM
Determining the size of a range.	Dave the wave	Excel Programming	3	June 30th 04 01:47 AM

All times are GMT +1. The time now is 11:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us