if statement and variable last row

[FROGGER24]

Hi all,
Formula in cell AN1
if cell T5 is blank return last value in column AL, otherwise use user defined function to get result

<Dim lr As Long
lr = Cells(Rows.Count, 38).End(xlUp).Row
Range("AN1").FormulaR1C1 = _
"=IF(R5C20="""",RC[-2] & lr,'abc def 2017.xlsm'!Ft_Uni2(R5C20))">
will need to populate cells until last value in column AL is found.

Thanks for any guidance, have a good day

 

[Fluff]

How about

"=IF(R5C20="""",R" & lr & "C[-2] ,'abc def 2017.xlsm'!Ft_Uni2(R5C20))"

 

[FROGGER24]

Thanks Fluff, code worked perfectly thanks

 

[Fluff]

You're welcome & thanks for the feedback