Solver function question...

R

romelsb

I try to solve a simple sudoku problem thru solver in a 9x9 matrix...and I
had downloaded from Andrew's Excel website a sheet/Data/Other
Utilities....and it helps me to merged/join all the changeable cell refs and
constraint definitions.....Yet unfortunately, I cannot paste it easily in the
solver's pop-up window slots for

a) By Changing Cells:
b) Subject To The Constraints :

I explore solver this way to enable me assure that I can enter all the above
without selection mistakes....Can someone help me to make this possible....

Can solver be triggered somewhere between the lines of a macro ? I dont know
anything about VBE....

Thanks for any trial solution...

"Bright minds are blessed to those who share them.."-rsb.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top