Thread: I need a macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
pcor pcor is offline
external usenet poster
 
Posts: 148
Default I need a macro

I would like a macro to do the following:
I would place the the cursor in any cell and this macro would give me the
average of all the entries to the left if the selected cell. EX: I place the
cursor in cell M12.
I want this macro on display in cell M12 the average of all the values from
Col C12 to Col L12. Note that there may NOT be entries in all the cells in
that range. Also the start point would always be col C .Thanks