Thread: Macro to insert formula
View Single Post
  #2   Report Post  
nobbyknownowt nobbyknownowt is offline
Member
  
Posts: 57
Default
sussed
Range("i13:j13").Select
ActiveCell.FormulaR1C1 = _
"=LOOKUP(R[-9]C[4],'AR7 calcs'!R[12]C[-1]:R[16]C[-1],'AR7 calcs'!R[12]C[7]:R[16]C[7])"
Reply With QuoteReply With Quote