Fill Down, but not locked into one value.

[ChrisAch]

Hi All

Im trying to fill down, however the fill down, gives me several thousand returns of the same value - what ever the value of O2 =

However cell 03, 4, 5 etc etc are all diff values, and therefore looking for the fill down, to factor this in and return the desired value.

I believe its because ive not used $ - but am unsure where to use these, or if that is the issue.

     Selection.AutoFill Destination:=Range("O2:O" & Cells(Rows.Count, "M").End(xlUp).Row)

Any ideas?

Thanks all.

[xavier73]

What have you selected in O. What has to be in column O?

[ChrisAch]

I didn't have auto calculation checked in my options panel. that fixed my issue :-)

thanks for the reply.