UDF error
I have a formula, that works, to find the last cell in a column: =Lookup(2,1/(rngInput"",rngInput)
I used the macro recorder to produce the following which also works:
Code:
---------
Sub Macro1()
ActiveCell.FormulaR1C1 = "=LOOKUP(2,1/(C[1]"""",C[1])"
End Sub
https://www.excelforum.com/sho....wthread.php?t=143660
Discover the world at Altruu, The Discovery Engine