Do you require a cell format or macro data entered into a cell via
macro?
for macro
activecell.value = format(now(),"yymmdd.hhmm")
In using the above code i have come across a problem where the dat
does not appear in the correct format. To overcome this problem i use
sDate$ = format(now(),"yymmdd.hhmm")
activecell.value = sdat
--
Message posted from
http://www.ExcelForum.com