View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Variable reference to noncontiguous cells...

Hi,

Am Thu, 30 Jan 2020 15:47:44 -0600 schrieb dpb:

This averages all the cells between MC:AC7, not just those for which
MOD(...,4)=1.


no, I tested it and it only averages the cell in M, Q, U, Y, AC


Regards
Claus B.
--
Windows10
Office 2016