Hi!

Hope someone can help me?

I am trying to find code (not great at writing macros - but ok at recording
them) that will enable me to use solver on a range of cells, then move to the
next range of cells and use solver again without going through the processes
of clicking on each one and going through the menus.

Does anyone have any suggestions if this makes any sense at all?

Thanks

Sarah

Why don't you start by recording the process for the first *two* sets
of ranges. Share the code and someone should be able to show you how
to generalize it.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hi!

Hope someone can help me?

I am trying to find code (not great at writing macros - but ok at recording
them) that will enable me to use solver on a range of cells, then move to the
next range of cells and use solver again without going through the processes
of clicking on each one and going through the menus.

Does anyone have any suggestions if this makes any sense at all?

Thanks

Sarah