Thanks snb
This code will convert the range to value .. and the UDF required to get the last row in the range (which has formulas) .. Or I missed something !!?