Growth function in VBA

[ronnie76]

I am trying to execute excel's growth function in VBA. I have a table that will continuously be updated adn I want the growth function to update also replaceing previously forecasted scores with actual scores entered. I beleive I would be able to make it work if I just understood how to enter the GROWTH funtion in VBA.

Thanks

 

[ronnie76]

I have tried the following code but I keep getting a run time error.

'Range("AC20").Select
'Range(Selection, Selection.End(xlToRight)).Select
'Selection.AutoFill Destination:=Range("AL20:BA20"), Type:=xlGrowthTrend