Knapsack Problem looping through Range

[Vin1988]

Hi all,

that`s my first post in this forum and its a little bit tricky. I hope u can help me out with this one
First off all I got a VBA Code to match a particular Sum with multiple summands from a given list of numbers. From the code so far I am able to type in a Sum and get the matches displayed.
Unfortunately I need to loop through a complete column of those "potential" Sums and paste the summands (Matches) one column next to it (or n columns for n summands).
I tried to change the range and add a "i" loop to it. But it seems that everytime I m doing it, mismatch Data pops up. So I wasnt able to set the Range to the whole column. For instance I tried .Range("B" & iCount) or Range("B:B") or Cells(iCount, 2) and so on
So my question here is whether I did the syntax wrong or could be problem with the arrays themselves?

Here is the Code related to setting up the range:

Please Login or Register  to view this content.

Here is the whole code, sub + function:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks for ur help, I really do appreciate it!

[mohd9876]

I think the problem is in this:

Please Login or Register  to view this content.

because you are trying to access a non array variable as array; so you should declare it as array or use it as non array