Thanks for that but it still only reads the first line of each ie J100 20

Teethless mama wrote:
use absolute reference isntead, change A1:D72 to $A$1:$D$72

I could just behaving a very thick day but help would be very much
appreciated.
[quoted text clipped - 34 lines]

Jane

--
Message posted via http://www.officekb.com