Solver with values not stored explicitly in cells

[Stacy35216]

Windows XP
Excel 2003

Hi people,

I'm trying to use Solver in an Excel add-in I'm writing. I can do it
fine given that I store all my Solver inputs in cells, but I don't want
to do that. My program is an involved math doohicky and I only use the
spreadsheet for I/O. Instead, I would like to use Solver on variables
declared and defined within the add-in but not ever displayed on the
spreadsheet.
Is this possible?

Thanks in advance,
Allison

 

[Tushar Mehta]

The free version of Solver works only with worksheet ranges. You may
find a priced version at www.solver.com (or a version at one of its
competitors at www.lindo.com) that works with arrays, etc.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions