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