Passing arguments to solver

[Karstedt]

I'm trying to make a function for solver that goes something like this:

Please Login or Register  to view this content.

SolverOk does not like this though... it does not like me using variables at all in fact. I've tried using explicitly defined variables, tried them as strings, and some other fruitless crap.

SolverOk is expecting, "Range("X:Y")", in place of my variables for anyone not familiar with Solver.

Can this be done, or is there some clever way to accomplish the same thing?

[shg]

Solver always works on the active worksheet, so

Please Login or Register  to view this content.

[Karstedt]

Fantastic, thanks. The reference I was looking at for the range object didn't mention using the .Address property.