Thread: Incorrect formula created
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Amil Amil is offline
external usenet poster
  
Posts: 11
Default Incorrect formula created
' given weekOffset = 1
Range("B2").Select
ActiveCell.FormulaR1C1 = "=A2+" & weekOffset
' produces a formula in excel as:
' ='A2'+1
' i was expecting something like: =A2+1
Reply With QuoteReply With Quote