1. P

    A GoalSeek Macro referencing output from another GoalSeek Macro

    I'm not entirely new to programming, but I am new to VB and Excel Macros. I am using Excel 2007 on Windows XP. I have a set of fields that I have a goal seek setup with this macro: Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Row = 1 And Target.Column = 9 Then...
  2. P

    Solver Root

    I created a trendline and associated equation for some data plotted against Time on the x-axis displayed in MM/DD/YY format. The date for the data ranges from 3/27/06 thru 11/10/08. The trendline equation is… F(x)=-6E-13x^5+1E-07x^4-.0087*x^3+329.1*x^2-6E+06*x+5E+10 The data actually crosses...

Some videos you may like

This Week's Hot Topics