View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lost Lost is offline
external usenet poster
 
Posts: 55
Default Goal Seek on multiple rows/columns???

I would like to write a macro that will goal seek. Then after the first goal
seek, I would like the macro to goal seek two cells to the right of the
original cell (12 times). Once the macro has gone through all the goal seek
cells horizontally, I also need the goal seek to work 9 cells down from the
original cell, and then 9 cells down continuously until it reaches a "STOP"

Each goal seek would have different criteria.

Thanks!