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

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