i have to run solver on four different sheets. output of 1st sheet will be used as input of 2nd and so on. i have recorded a macro to run the solver for all 4 sheets one by one. but when i run the macro it stops at every sheet and ask to enter manually to confirm "keep the result". can anybody help with this.