Thread: i'm looking for VB code that does the same as hitting F2 in excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
witek witek is offline
external usenet poster
  
Posts: 69
Default i'm looking for VB code that does the same as hitting F2 in excel
dn wrote:
when you record a macro hitting the F2 in a cell that contains 444, the
result is:
ActiveCell.FormulaR1C1 = "444"
i would like the code just to record the action of hitting the F2 not of
writing the existing cell formula



Application.SendKeys "{F2}"
Reply With QuoteReply With Quote