View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dorre dorre is offline
external usenet poster
 
Posts: 12
Default programatically entering a CSE formula

hi folks

What is the correct way to enter a CSE formula into a range of cells?

With Sheet1
.Range("A10:C70").Formula = "=SUM(lARGE((" .... etc... "
End With

This works for non-CSE formulas, but how do I enter CSE ones?

much thanks
Dorre