04-24-2012, 11:44 AM
Hi,
I have quite a similar question.
I am using the following code
Problem is value is saved one by one in A1 cell, so when i run the program the values changes one by one in cell A1 and at the end I just get the last value.
I want to save all the values like
cell A1 123
cell A2 456
etc.
Looking for responses
I have quite a similar question.
I am using the following code
Code:
numb="123 456 545"
words=split(numb, " ")
For i=lbound(words) to ubound(words)
msgbox(words(i))
Datatable.Value("Data", dtGlobalSheet)=words(i)
next
Problem is value is saved one by one in A1 cell, so when i run the program the values changes one by one in cell A1 and at the end I just get the last value.
I want to save all the values like
cell A1 123
cell A2 456
etc.
Looking for responses