Fantastic, thank you for that - I knew that there was a way!
Stefi wrote:
I couldn't figure out what do you want to do (eg. what is "IS" in Sumif
formula, where LAST without a number is defined), but
ActiveCell.formula = "=SUMIF(D7:LAST,""IS"",D8:LASTi)"
should be written in this way:
ActiveCell.formula = "=SUMIF(D7:LAST,""IS"",D8:LAST" & i & ")"
Regards,
Stefi
€˛lesley1000 via OfficeKB.com€¯ ezt Ć*rta:
I have named in excel 70 cells - I have named them LAST1, LAST2,..., LAST70.
They are in the same column, one underneath the other.
[quoted text clipped - 19 lines]
Any help?
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200712/1