Prompt:='Select the range which the ''Set Cells'' will be changed to', Default:=Range('B8:E8').Address, Type:=8) InputBox(Title:='Select a range in a single row or column', _ 'prompt:='Select your range which contains the ''Set Cell'' range', Type:=8) Prompt:='Select your range which contains the ''Set Cell'' range', Default:=Range('B6:E6').Address, Type:=8) The code that computes the first row only is:ĭim TargetVal As Range, DesiredVal As Range, ChangeVal As Range, CVcheck As Range There is one that I can get to work but it only does the first row, not any of the ones under it (so it essentially is doing what regular goal seek does). I am not very familiar with macros or codes or anything like that, but I have tried to copy a few macros. Ideally I would just be able to select a range of cells rather than have to manually type in a value in the 'To value:' text box of the goal seek window. I wish I could just copy and drag down the formula. I am wondering if there is a faster way to do this than individually using goal seek over and over. I have rows and rows of data that need this same function performed (each with their own value to be changed to). I am using Excel 2004 for mac and have been able to use the goal seek function to solve an equation.