Having problems writing macro in Excel

[ernestgoh]

hi,

i am trying to write a goalseek macro with a minimum GoalSeek Goal to generate premium rates for different ages.

i have a group of people from
age = 17 to 60

and i set my goal to be
profit margin = 10% for age 17 to 30
= 20% for age 31 to 60

so i need to change the premium rates


i can get the standard macro but i would like to vary the profit margin by age
Range("AK129").GoalSeek Goal:=0.10, ChangingCell:=Range("D12").

Appreciate any help on this. Thanks!

[ernestgoh]

hi,

i am trying to write a goalseek macro with a minimum GoalSeek Goal to generate premium rates for different ages.

i have a group of people from
age = 17 to 60

and i set my goal to be
profit margin = 10% for age 17 to 30
= 20% for age 31 to 60

so i need to change the premium rates


i can get the standard macro but i would like to vary the profit margin by age
Range("AK129").GoalSeek Goal:=0.10, ChangingCell:=Range("D12").

Appreciate any help on this. Thanks!

anyone has any idea what i mean? thanks!