Array saving a value - Microsoft Community
if challenge!
im looking copy cell n times array. using loop.
here dilemma
dim integer
dim j integer
set j=range("a3").value
dim myarray(80)
i=1 i<j
[this part stuck. need specific cell copied array values 1 j. j being cell value of cell. dont want set value of cell myarray. want save value of cell, cell a3, different parts of myarray.
so if cell a3 contains string, "htotheizzoztotheizzay" then
myrarray( 1 5) =htotheizzoztotheizzay
im looking copy cell n times array. using loop.
here dilemma
dim integer
dim j integer
set j=range("a3").value
dim myarray(80)
i=1 i<j
[this part stuck. need specific cell copied array values 1 j. j being cell value of cell. dont want set value of cell myarray. want save value of cell, cell a3, different parts of myarray.
so if cell a3 contains string, "htotheizzoztotheizzay" then
myrarray( 1 5) =htotheizzoztotheizzay
you have created j integer - integer can't hold text.
do want j length of text in cell a3, or want j string variable?
Office / Excel / Windows 10 / Office 2013
Comments
Post a Comment