How do I create a macro from a SUMPRODUCT formula for a range whose number of rows changes

Originally Posted by watersev

hi bananius,

total = ActiveSheet.Evaluate("SUMPRODUCT(--(MMULT(--(" & Range1.Address & "=" & """VAC""" & "),{1;1;1;1;1;1;1;1;1})<5))")

Thank you for your help watersev!!!! It worked! Do you always have to put ".Address" when referring to a range? Also why are there two sets of quotation marks around ""VAC""?

Thanks again!!!