Thread: formula array gives compile error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
R..VENKATARAMAN R..VENKATARAMAN is offline
external usenet poster
  
Posts: 41
Default formula array gives compile error
the following statements give compile error

Set rng1 = Worksheets("sheet1").Range("c1:c10")
rng1.FormulaArray="=range("a1:a10")+range("B1:B10" )

what is the mistake and what is the correct statement


Reply With QuoteReply With Quote