Run Time Error 1004 pasting formula into worksheet using VBA.

Hi,

I have this piece of code which is giving me an run-time error "1004". I think i figured out the problem but wanted to ask


The vba code is as follows to insert a formula into a specific workbook-worksheet-cell locastion:

Please Login or Register  to view this content.

in the example code above let x=1



Now the strange thing is that if the

fl_new = "Copy of empty_4_4_notemptyNewemptyOld_DET.xlsm" CODE FAILS


fl_new = "tst_4_4_Junk_DET.xlsm" CODE DOES NOT FAIL


So i have narrowed down the problem to the file-name. I manually opened the failing file and manually typed in this formula

Please Login or Register  to view this content.

and it took it.......again i manually did this not using vba.............



ANY IDEAS why using VBA in the manner i did would cause this problem?