Thread: Variable in a formula
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default Variable in a formula
what about the other on<vbg

ActiveCell.FormulaR1C1 = "=MID(R2C5,Sheet1!R[" & your_variable &
"]C2,Sheet1!R[[" & your_variable & "]]C1)"

$#&"! missed that one :-)

Reply With QuoteReply With Quote