Hello,
I still need to assign a value to a cell within VBA, just before I do the SolverSolve command. I think I should use the .range command? I would like to know if I can use it without a specific worksheet specified? This macro will be used on 30 or 40 sheets of the notebook. I'm thinking of using something like:
Worksheets("Sheet1").Range("A5").Value = 50

But I don't want the "sheet1" in there. I want it to work for any sheet,
or the active sheet, whatever. Can I make this sort of command work for any sheet?
Thanks for any help,

Rick