working with array

[ersatz]

Hi,
I take from a server 100 data like this:
e0=a
e1=b
.
.
e100=zz
Now I want to verify if one of these values is 0 and if so, I want to change with 10.
Can anybody help me?
Thanks in advance,
Ersatz

 

[VulcanJedi]

sub CheckArrayElementZero()

dim e() as array
for x = 1 to 100
if e(x) = 0 then
e(x) = 10
end if
next x
end sub Tranpkp
************************************
- Let me know if this helped/worked!
Please remember to give helpful posts the stars they deserve!
This facilitates others navigating through the threads / posts!

 

[ersatz]

thanks!

 

[VulcanJedi]

I was hoping that worked. Thought perhaps you were looking for something else. Tranpkp
************************************
- Let me know if this helped/worked!
Please remember to give helpful posts the stars they deserve!
This facilitates others navigating through the threads / posts!

 

[ersatz]

Now I have another problem.
I have access columns like this:
Field1 800 810 820 830 etc 880
891.5 a d m
820 b e n
879.32 c f o
etc
I must compare my data from Field1 with the name of other columns.
Ex:

If my Field1 value is 879.32 I must go in "880" column to take the correspondent value and to put that value in a new field, Field2