View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mona Mona is offline
external usenet poster
 
Posts: 69
Default excel formula and vba

I have this formula in cell:
=SUM(C12:L12)/((COUNTIF(C12:L12,"=0"))*24)

I need to be able to "convert" this to vba code.
??
thanks!!