Hello,
I tried the following code to insert values to some cells, but it didn't worked as intended:
It "pasted" only the first value of the matrix ("0") in all cells C4:C6.
Please Login or Register to view this content.
Could any one help-me? I would like to avoid loops, if possible.
Thank you
Hi Et_Dux,
try to use a two-dimensional array
Please Login or Register to view this content.
Hello Friend.
You have created a Horizontal array and are saving it into a vertical selection.
If you modified your selection to "C4:D6" you would see your array saved three times.
You need to Transpose your array.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Wow! thank you, guys!! Cheers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks