ChrisAch
08-11-2016, 04:51 AM
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.
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.