PDA

View Full Version : Fill Down, but not locked into one value.



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.

xavier73
08-11-2016, 05:52 AM
What have you selected in O. What has to be in column O?

ChrisAch
08-15-2016, 08:51 AM
I didn't have auto calculation checked in my options panel. that fixed my issue :-)

thanks for the reply.