View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
crapit crapit is offline
external usenet poster
 
Posts: 75
Default How to insert formula to a range of cells from VBA?

How do i insert the following formula from range e2 to j26?
IF(OR(ISERROR(E2-TODAY()),ISBLANK(E2)),"Not
Available",IF(E2-TODAY()<0,"Expendite",E2-TODAY()) )