Thank you for that quick respons Colin. I read through it and it looks very good. It is a little more than I needed though; maybe I just do not code the correct way ;-). I did get it to work...
Quote:
I believe I have acheived my result...
I defined the variable wrong. It needs defined as a variant (may be usefule to use a different defining value but right now this one works) then just set the variable equal to the array wanted.
Quote:
Dim arrayV As Variant
for j = 1 to 2
if j = 1 then
arrayV = dataL
else
arrayV = dataF
end If
...code
next j
simple change :-S
|