View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shannon Shannon is offline
external usenet poster
 
Posts: 11
Default Writing Macros in Excel

Am trying to write a Macro that looks at three fields
(cells) and gives me the Minimum, Maximum, and Average
into another specified field, i.e. Cells(i, 7).Value = Min
(Cells(j, 2)(k, 2)). Get error message that Min is an
undefined Sub or Function. How do I calculate the Min?