Hello All,
k, I can't seem to get this to work tried everything I
could think but still not working. I have followig code:
Dim LastRow as Long
Dim LastRow1 as Long
LastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row
Lastrow1 = ActiveSheet.Cells(Rows.Count, "O").End(xlUp).Row
Range("K15").Select
ActiveCell.FormulaR1C1 = "=R[-14]C[-10]"
Range("K15:K" & LastRow).Filldown
Range("L15").Select
ActiveCell.FormulaR1C1 = "=R[-14]C[3]"
Range("L15:L" & Lastrow1).Filldown
But nothing gets copied. If I change End(xlUp) to Xldown,
it does work, but as u know it copies all the way down.
So not sure what I'm doing wrong. So seems the filldown
not working. So need somethign like:

Any suggestions how I can fix this?
Thanks for any help provided.
Juan