I have the following code:
I also enclosed file with data and code as well.
For some reason when i try to put the contents of the array into the worksheet it does not work.......i think i am doing it correctly.
Please Login or Register to view this content.
because you redimension the array you have in fact made it 2 columns wide instead of 1 due to zero base arrays.
Please Login or Register to view this content.
how on earth did you ever figure that out!!!!!!!!!!!!!
How would i have seen / know that i changed the dimension of the array........
I will make the array Option base 1.
After i added the code "Option base 1" .......everything worked. I did not have to add your code......but i will try that as well.
Also, in the future how can i debug my code better to have seen such a thing?
thanks!
First thing I did was put something column G to see if the array was being outputted. Although the data in G was replace it was not with any data.
So next I checked the array actual contained data, which I did. Then I use Lbound and UBound to see the size of the array and notices it as 2 across not 1.
Also try using your locals window, this is good for arrays as it's easy to see the dimensions and the data contained in them
Also try to reduce the code:
e.g.
Please Login or Register to view this content.
Last edited by snb; 10-14-2011 at 10:27 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks