View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Modify Code to loop back through table after its been updated and process it

I'm curious as to whether or not you can simply load the attributes
into an array and 'dump' the array into a blank worksheet like this...

XlSheet.Cells(1).Resize(Ubound(Array1), Ubound(Array1, 2)) = Array1

...which assumes Array1 becomes a 2D array after the attributes are
loaded into it!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus