I have a very simple set up with 40 rows and 3 columns (that I am going to have to use over and over). TargetVal.Cells(i).goalseek Goal:=DesiredVal.Cells(i).Value, ChangingCell:=ChangeVal.Cells(i) "Goal seek only works if the cells to be changed are values, please ensure that this is the case", vbCritical MsgBox "Changing value range contains no blank cells or values" & vbNewLine & _ Set CVcheck = Intersect(ChangeVal, Union(Sheets().Cells.SpecialCells(xlBlanks), Sheets().Cells.SpecialCells(xlConstants))) 'Ensure that the changing cell range contains only values, no formulas allowed 'prompt:="Select the range of cells that will be changed", Type:=8) Prompt:="Select the range of cells that will be changed", Default:=Range("B4:E4").Address, Type:=8) InputBox(Title:="Select a range in a single row or column", _ 'prompt:="Select the range which the ""Set Cells"" will be changed to", Type:=8) Prompt:="Select the range which the ""Set Cells"" will be changed to", Default:=Range("B8:E8").Address, Type:=8)
'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)
#MS EXCEL FOR MAC GOAL SEEK CODE#
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.
0 kommentar(er)
