Thread: Inserting formulas depending on a variable
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alexander Alexander is offline
external usenet poster
  
Posts: 21
Default Inserting formulas depending on a variable
It is possible to insert a formula in the cell by Formula property, for
instance:
Range("A1") Formula = "=Sum(A2:A12)"
How can I to change cells which are used in formula, depending on a
variable. For instance, I need to change the range A2:A12 to Ax:Ay depending
on variable - rng=Range("Ax:Ay") ?
I am using Excel2003.
Reply With QuoteReply With Quote