Thread: autotab
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mats mats is offline
external usenet poster
 
Posts: 16
Default autotab

Hi,
I made a "short" macro with a button that is going to enter the time of
day....but would also like to "autotab to next cell" for the next time stamp.
How do I fix that? See code below.

Sub TimeStamp()
ActiveCell.Value = Format(Time, "h:m ampm")
End Sub


Regards Mats