I have 17 columns A to R.
I want to use the TREND function to enter values in column R, starting at row 3.
I have the following code successfully for rows 3 to 39:
sub test()
dim lastforecastmonth as long
lastforecastmonth=cells(rows.count, "A").end(xlup).row
range("R").select
for I=0 to...