julisimo wrote:
Thanks Bill Martin,
i thing that will be hlpfull form me...
but if you paste some example :) - will be great. I'm not very good in VBS
and macros.

Thanks in advance

Bob Phillips gave you one way to do this. Here's how Excel created it
for me just from recording keystrokes (and a little follow up editing to
clean it up):

-------------------
Sub DateToday()
'
' DateToday Macro
' Macro recorded 11/26/2004 by wjm
'
' Keyboard Shortcut: Ctrl+d
'
ActiveCell.FormulaR1C1 = "=TODAY()"
Selection.NumberFormat = "mm/dd/yy"
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False ' Esc key
End Sub
------------------


Good luck...

Bill