Thread: use CTRL key inside a macro IE CTRL + ;
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Date Less Date Less is offline
external usenet poster
  
Posts: 1
Default use CTRL key inside a macro IE CTRL + ;
I want to insert a static date into cell b2 based on what is in a2 [ =
if(a2="yes",today(),"nothing") The date changes when you open the program.
I want to use CTRL key inside a macro IE CTRL + ; to put in a static date.
Reply With QuoteReply With Quote