Change solver variables in vba

I have a VBA Module that pulls data from different areas of a spreadsheet and runs them through solver ,making a binary column of 1's and 0's to get my solution. My question is every time the amount of data it pulls in to solve is different for example one time it may be 20 items then next 200. Is there anyway to edit the solver criteria to reflect that based on the amount of items it brings in for example my binary column is G so instead of always having it as G2:G200 when it only copy's in 75 items it would change it to G2:G75?

Thanks
Adam

Are you running solver in a loop? As I've not seen you model my suggestion must be a guesstimate but perhaps something like this?

If you are importing the data for solver to work on say to the A column going from A2 to A?? you could perhaps do like this

Please Login or Register  to view this content.

Alf