View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] gaba53@hotmail.com is offline
external usenet poster
 
Posts: 4
Default Help seperate Arrays

I'm certain this is not very difficult, but for some reason I am
having difficulty accomplishing what I want.
iobj_dom could contain values like AB, AC, AD2, AF etc. When I write
it I want the values seperated by commas as shown, but what I get is
ABACAD2AF. There could be 1 to ??? elements in the array.

For Each iobj_node In iobj_dom.documentElement.childNodes
ReDim sys(iSys)
sys(iSys) = iobj_node.childNodes(0).Text
iSys = iSys + 1
Next
Range("C" + CStr(ll_range)).Value =
iobj_dom.documentElement.Text

Thanks in advance,
Gabe