Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Write to DataTable
#5
Solved: 11 Years, 3 Months, 3 Weeks ago
Hi,

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 Smile
Reply


Messages In This Thread
Write to DataTable - by bgold01 - 04-21-2012, 01:11 AM
RE: Write to DataTable - by sshukla12 - 04-23-2012, 10:59 AM
RE: Write to DataTable - by bgold01 - 04-24-2012, 01:01 AM
RE: Write to DataTable - by sshukla12 - 04-24-2012, 09:30 AM
RE: Write to DataTable - by bgold01 - 04-24-2012, 06:12 PM
RE: Write to DataTable - by sshukla12 - 04-24-2012, 06:15 PM
RE: Write to DataTable - by bgold01 - 04-24-2012, 06:29 PM
RE: Write to DataTable - by sshukla12 - 04-25-2012, 10:12 AM
RE: Write to DataTable - by srikanthqtp - 04-29-2012, 06:01 PM
RE: Write to DataTable - by hamzaz - 04-24-2012, 11:44 AM
RE: Write to DataTable - by sshukla12 - 04-24-2012, 02:38 PM
RE: Write to DataTable - by hamzaz - 04-24-2012, 02:51 PM
RE: Write to DataTable - by sshukla12 - 04-24-2012, 04:13 PM
RE: Write to DataTable - by hamzaz - 04-24-2012, 04:17 PM
RE: Write to DataTable - by sshukla12 - 04-24-2012, 04:55 PM
RE: Write to DataTable - by hamzaz - 04-26-2012, 07:20 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Datatable add and datatable import sheet wheelercha 4 33,625 06-14-2012, 04:53 PM
Last Post: Arul

Forum Jump:


Users browsing this thread: 6 Guest(s)