I make this kind of string formula:

="=IF($C14=$CC$5;"&"$CC$5;IFERROR("&"VLOOKUP($C14;"&"'"&REPLACE(CELL("filename");FIND("[";CELL("filename");1);(FIND("]";CELL("filename");1)+1-FIND("[";CELL("filename");1));'SETING AWAL PERIODE'!$Y$10)&"'!"&"$C$15:$CU$215;"&"'"&REPLACE(CELL("filename");FIND("[";CELL("filename");1);(FIND("]";CELL("filename");1)+1-FIND("[";CELL("filename");1));'SETING AWAL PERIODE'!$Y$10)&"'!"&"CM$14;FALSE);$CC$5))"

Then copy Value to another Cell, it become a kind of active Formula:

=IF($C14=$CC$5;$CC$5;IFERROR(VLOOKUP($C14;'D:\YOVAN\INDUSTRI\MONTHLY SALARY\[SalaryNopember2014.xlsm]ABSENSI'!$C$15:$CU$215;'D:\YOVAN\INDUSTRI\MONTHLY SALARY\[SalaryNopember2014.xlsm]ABSENSI'!CM$14;FALSE);$CC$5))

The problem is this formula only active after pressing F2 and Enter

Please help me how to make this formula automatically active without pressing F2 and Enter

And the code in VBA if still need using F2 Enter.

Thanks For any helping hands

## Bookmarks