Hi, I am trying to use a variable (rowNo), which is an integer an
refers to a row number, in this statement:

Range("n5").FormulaArray = "=SUM(J12:J"&rowNo&")"

so that the range is from cell J12 down to JrowNo (what ever rowNo i
it will be greater than 12).

I cannot figure out how to get this to work...
Is this even possible?
Thanks and regards
E

--
Message posted from http://www.ExcelForum.com