Thread: Syntax to insert an array formula in a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Karthik Bhat - Bangalore Karthik Bhat - Bangalore is offline
external usenet poster
  
Posts: 25
Default Syntax to insert an array formula in a cell
Hi Mike

You need to use the FormulaArray function

This code should work :

Range("E4").FormulaArray = "=SUM(--SUBSTITUTE(0 & R[3]C:R[66]C, "" -
"",""""))"

Thanks
Karthik Bhat

Reply With QuoteReply With Quote