View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KiriumF1 KiriumF1 is offline
external usenet poster
 
Posts: 23
Default worksheet function?

Mm..how to write average worksheet function in VBA? worksheetfunction.average?

How do I reference to the range of cells in another worksheet? Is it like
this, WorksheetFunction.Average (Range("fulldata for c1")("C3:C9"))?

Thanks!