Help formula VBA incorrect calculation when placed in array

[Rubygas14]

Hi all

The below formula works but i need this to work up to the last row in K when i drag the formula down to autofill the formula works for 1st 10 cells then i receive a #VALUE !

i can put this in to array but it the locks all cells to k3 and give me the incorrect calculation.

this is throught VBA

 Lastrow = Cells(Rows.Count, "K").End(xlUp).Row
       Range("L3:L" & Lastrow).Select
       Selection.FormulaArray = "=IF(OR(RC[-1]=Hour),TEXT(Post,""dd/mm/yyyy"")&TEXT(Rc[-1],"" ""&""hh:mm""),TEXT(Pre,""dd/mm/yyyy"")&TEXT(Rc[-1],"" ""&""hh:mm""))"
      Lastrow = Cells(Rows.Count, "j").End(xlUp).Row[code]

Any Help will be Great 

Thanks

 

[Fluff]

Re: Help formula VBA incorrect claculation when placed in array

Try

LastRow = Cells(Rows.Count, "K").End(xlUp).Row
Range("L3").FormulaArray = "=IF(OR(RC[-1]=Hour),TEXT(Post,""dd/mm/yyyy"")&TEXT(Rc[-1],"" ""&""hh:mm""),TEXT(Pre,""dd/mm/yyyy"")&TEXT(Rc[-1],"" ""&""hh:mm""))"
Range("L3:L" & LastRow).Filldown
LastRow = Cells(Rows.Count, "j").End(xlUp).Row

 

[Rubygas14]

Re: Help formula VBA incorrect claculation when placed in array

Great thanks

 

[Fluff]

Re: Help formula VBA incorrect claculation when placed in array

You're welcome