Log in

View Full Version : Special macro for range goal seek


Conrad
06-12-2009, 06:05 AM
Hello everybody,

I need a macro wich will make a goal seek for a range of cells that I select AND, if in some cases there is no solution found, to display in that cell a message or a number... Can somebody give me a hint?

Thanks in advance!

Conrad
Conrad
06-15-2009, 01:17 AM
...so it is complicated...???
grichey
06-15-2009, 05:41 AM
a range?? Can you not use solver?
Conrad
06-15-2009, 06:45 AM
a range?? Can you not use solver?
...unfortunatelly not, because in solver, the "Set Target Cell" must be a single cell and I need to select a range (on column or row) for this input...
grichey
06-15-2009, 06:52 AM
the input is 'changing cells' which can be a range.
Conrad
06-15-2009, 09:16 AM
the input is 'changing cells' which can be a range.
...err...not exactly... the input is also the "set target cell" - which I want to select as a range, but in solver is impossible...
slamet Harto
06-16-2009, 07:29 PM
like this :
http://www.vbaexpress.com/kb/getarticle.php?kb_id=433
xls
06-16-2009, 11:37 PM
WHAT ABOUT DATA TABLE.

TRY IT
:think: