Thread: What's wrong with this code (r1c1 paste)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mmattson mmattson is offline
external usenet poster
  
Posts: 1
Default What's wrong with this code (r1c1 paste)
ActiveCell.FormulaR1C1 =
"=IF(AND((VALUE(YEAR($I6)&MONTH($I6))<=(VALUE(2004 &N$5))),(VALUE(YEAR($J6)&MONTH($J6))=VALUE(2004&N $5))),1,0)"

Reply With QuoteReply With Quote