Thread: array formula in macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ezil ezil is offline
external usenet poster
  
Posts: 43
Default array formula in macro
The following array formula is working when directly written in cell. But I
have to do
this through a macro. How to write the following command line correctly in a
macro.

Range("b3") = "=MIN(if(a2:a1000,a2:a100))"
Reply With QuoteReply With Quote