vba goal-seek

  1. T

    VBA Goal Seek

    I'm still new to this but can someone help me how to set goal seek "set cell" must be in ascending For example cell B83 "set cell" is the sum of B71:B82 (must be ascending) and cell B85 is the "to value" and cell b70 is "by changing cell" also, cell b71 is a hard code cell cell b72...
  2. C

    VBA for a multiple GoalSeek on three rows

    Hi all, That has to be dead simple but I can figure it out (a beginner!). I have three rows: 5, 12 and 19. my columns run from L to BM for all three lines. What I need is a loop that does this: Range("L5").GoalSeek Goal:=Range("L12").Value, ChangingCell:=Range("L19") .... but for the...
  3. J

    VBA goal-seek

    I have a named range called Periods which = 45 and i want this cell to change the range below. How do I change Range.("N45") to pick up column N but pick up the name range Periods which will be changed by the user? Sub Macro1() ' ' Macro1 ' ' Sheets("Cashflow").Range("N45").GoalSeek...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top