P PipBoy808 Member Mar 7, 2014 #1 Hi, I'm trying to use format to format a date object as "dd mmm yy", i.e. 07 Mar 14. The following keeps returning an 'object required' error: Code: Dim MyDate as Date MyDate=Range("A1").value Format(MyDate) = "dd mmm yy" Can anyone help me?
Hi, I'm trying to use format to format a date object as "dd mmm yy", i.e. 07 Mar 14. The following keeps returning an 'object required' error: Code: Dim MyDate as Date MyDate=Range("A1").value Format(MyDate) = "dd mmm yy" Can anyone help me?
SirJB7 Excel Rōnin Mar 7, 2014 #3 Hi, PipBoy808! What do you mean by "Date Object"? If it's a cell range like A1 then Arturo's suggestion will do the job but for the variable MyDate, not for your referred object. Could you please elaborate or post a sample file? Regards!
Hi, PipBoy808! What do you mean by "Date Object"? If it's a cell range like A1 then Arturo's suggestion will do the job but for the variable MyDate, not for your referred object. Could you please elaborate or post a sample file? Regards!
