Dear all,
i tried this now for some time but cannot figure it out. I want to enter the following formula in Cell C7:
   
rance("C7").select
ActiveCell.Formula = "=DATE(LEFT(B2;4);MID(B2;5;2);RIGHT(B2;2))"
however I alwys get a runtime error 1004: 'application-defined or object-defined error'.

could anyone tell me what i am doind wrong? if I leave the equal sign, then the text is entered in the cell.....


thanks everyone!