Posted to microsoft.public.excel.programming

MrShorty[_10_] MrShorty[_10_] is offline

external usenet poster

Posts: 1

Solver macro

My usual workaround for this issue is to set up another cell (say G2
for your example) and put the formula =f6-f28 in that cell. Then you
Solver criteria becomes 'set cell G28 to a value of 0

--
MrShort
-----------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...fo&userid=2218
View this thread: http://www.excelforum.com/showthread.php?threadid=38641

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Is it possible to run Solver using a macro?	EA405	Excel Worksheet Functions	1	May 2nd 06 08:05 PM
SOLVER macro	emilija	Excel Programming	1	April 22nd 05 02:29 PM
Solver Macro	Michael	Excel Programming	2	May 21st 04 03:13 PM
Using Solver within Macro	Avner Mediouni	Excel Programming	1	October 27th 03 12:08 AM
Solver Macro	Dick Stumbo	Excel Programming	0	September 18th 03 01:55 AM

All times are GMT +1. The time now is 01:10 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us