LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Solver with values not stored explicitly in cells


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


--
Stacy35216
------------------------------------------------------------------------
Stacy35216's Profile: http://www.excelforum.com/member.php...o&userid=15952
View this thread: http://www.excelforum.com/showthread...hreadid=486075

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use values stored in a combo box control? Arlen Excel Discussion (Misc queries) 4 July 25th 08 09:34 PM
Can I use solver to estimate several values by changing several c. AO Excel Worksheet Functions 1 June 24th 08 07:09 AM
How to explicitly set the regional code of an individual spreadsheet Scott Steiner Excel Discussion (Misc queries) 1 November 21st 05 02:34 PM
How do I denote values stored in columns in my macro? Greg Excel Programming 3 June 8th 05 07:43 PM
vba clearing out values stored in array chick-racer[_44_] Excel Programming 2 December 1st 03 09:05 PM


All times are GMT +1. The time now is 09:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"