View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tomerdr@gmail.com is offline
external usenet poster
 
Posts: 6
Default How to programmatically create range for solver?



I have a sheet in which the user can select some rows using check
boxes.
the rows contains cells in columns 1,2 and 10,11 which the solver need
to change.
How can i create a range containing all the cells based on the
collection?

Thanks in advance