Posted to microsoft.public.excel.programming

Alan Beban[_2_] Alan Beban[_2_] is offline

external usenet poster

Posts: 783

Access Array by index

Souris wrote:
dim ARR as variant
dim k as integer
dim i as integer
ReDim ARR(1 To k)

For i = 1 To k
If ARR(i).Value Is Empty Then ARR(i).Value = 0
Next i

I wanted to fill 0 if the index of array is null or empty.
It seems that above code didi not work.
Can you please tell me where I was wrong?
Thanks millions,

If IsEmpty(ARR(i)) Then ARR(i) = 0

Alan Beban

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
Help in finding Value in Index Array	George	Excel Discussion (Misc queries)	20	October 29th 07 11:48 PM
Index array question	LJoe	Excel Worksheet Functions	2	August 27th 07 02:14 PM
Vlookup with col index no. array	Edward	Excel Discussion (Misc queries)	1	September 18th 06 08:23 PM
Using Array Index function in a sub	General	Excel Programming	2	February 3rd 05 08:28 AM
Index of Minimum value in array	Paul Stevens	Excel Programming	17	December 8th 03 11:36 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us