View Single Post
  #7   Report Post  
Hari
 
Posts: n/a
Default

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