Thread: [Solved] re-naming arrays in VBA?
View Single Post
 
Old 03-15-2012, 08:34 AM
JDevsFan JDevsFan is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Mar 2012
Posts: 3
JDevsFan is on a distinguished road
Default

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
Reply With Quote