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
Bookmarks