I posted previoulsy that I needed to select the cell below a column o
numbers in order to calculate a sum. I have that.

range("I1").End(xlDown).Offset(1, 0).Select 'Next Blank Cell in colum
i

I need coding to add to this line which will allow me to calculate th
sum of the column. I need the coding to account for spreadsheets wit
different numbers of rows.

Thanks

Pau

--
Paul
-----------------------------------------------------------------------
Paulg's Profile: http://www.excelforum.com/member.php...fo&userid=3607
View this thread: http://www.excelforum.com/showthread.php?threadid=56215