View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Albert[_6_] Albert[_6_] is offline
external usenet poster
 
Posts: 7
Default How to calculate this on all rows?

Today I discovered the global scripting possibilities in Excel.
Until now, in cell I2, I calculated the average of 3 values like this:

=GEMIDDELDE(F2:G2:H2)

'Gemiddelde' means 'average' in Dutch (I use a Dutch Excel).

I'd like to make the sheet do this on all rows. Any ideas?
It shouldn't be too hard I guess, but I'm not a VB programmer.

Thanks,

Albert