Hi julisimo,
Why dont u try Bob's suggestion of "Can you use keys, Ctrl-:, and
Ctrl-Shift-;?"
Anyway here's is the VBA macro stuff (modify it as per ur requirements).
Paste this in the
VB editor (Alt +F11) after doing INSERT Module
Sub Macro1()
'
' Macro1 Macro
Range("E10").Select
ActiveCell.FormulaR1C1 = "=TODAY()"
Range("E10").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
End Sub
Thanks a lot,
Hari
India
"julisimo" wrote in message
...
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