View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] C.Pirabu@gmail.com is offline
external usenet poster
 
Posts: 2
Default Inserting a Static Date and Time thru a Macro

Hi!

I have to insert a Static Date and Time in a Cell thru a Macro.

I know the key strokes for this function.

Current date Select a cell and press CTRL+;
Current time Select a cell and press CTRL+SHIFT+;

But I need to accomplish this in a Macro. Could anyone help me with
this?

When I tried to record a macro to capture these key strokes it didn't
work.