Hi Rob,

Maybe a typo?
--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
Leave out the quote before myfile

"Rob" wrote in message
...
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