Glaswegian
09-17-2009, 02:18 AM
Hi
I'm trying to run a simple goalseek but I keep receiving a "1004 - application error" - and I cannot work out why.
The workbook is a financial calculator. I need to get to zero to determine a final payment amount, which will usually be different from the regular payment amount.
Sub GoalSeeker()
Calculate
Sheets("Lists").Range("J3").GoalSeek goal:=0, changingcell:=Sheets("Start").Range("E22")
End Sub
Users input some basic data and behind the scenes I work out fractions of a year, interest, take account of holidays etc and then create a basic payment schedule for users.
I've only used Goalseek once before and it worked fine so I'm a bit unsure why I'm receiving the error.
Thanks.
I'm trying to run a simple goalseek but I keep receiving a "1004 - application error" - and I cannot work out why.
The workbook is a financial calculator. I need to get to zero to determine a final payment amount, which will usually be different from the regular payment amount.
Sub GoalSeeker()
Calculate
Sheets("Lists").Range("J3").GoalSeek goal:=0, changingcell:=Sheets("Start").Range("E22")
End Sub
Users input some basic data and behind the scenes I work out fractions of a year, interest, take account of holidays etc and then create a basic payment schedule for users.
I've only used Goalseek once before and it worked fine so I'm a bit unsure why I'm receiving the error.
Thanks.