I'm trying without success to place the following formula into cell C1 via
VBA code, the formula works fine within the spreadsheet:

=VLOOKUP(LEFT(A1,3),myfile.xls!Database,2,FALSE)&" "&A1&" W/E:
"&TEXT(B1,"dd-mmm-yyy")

So far i've got this part to work but the A1 and B1 elements just don't want
to know!

Range("C1").Formula = "=VLOOKUP(LEFT(A1,3),"myfile!Database,2,FALSE) "

Any help will be most welcome. Rob