Hi everyones,
I would like to know if there is a way to paste directly values of a
matrix column or row without any loop.
I would like to have my program running faster and I have to compute
values of a VBA matrix column in an excel column but I don't know how
to do without a FOR loop and it is very slow to write in excel this
way.
for now my loop is like this:
Sheets("sheetname").Select
For j = 1 To 1000
cells(j , 1) = matrixname(j , 1)
Next j
I would like to take the entier colums 1 of my matrix in one time and
paste it into my excel sheet if it is possible.
If anyone could help that would be nice.
Thanks
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to [email protected]
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
