code for sum of sht with diff # of rows

[Paulg]

I need some code that will allow me to select the first blank cell at the bottom of a column of numbers and calculate the sum. My problem is that each spreadsheet I import has a different number of rows, and I don't know how to select the number of rows specific to that spreadsheet from the blank cell at the bottom. My previous macros recorded the number of rows in the spreadsheet I recorded the macro in.

Thanks

Paul

[Die_Another_Day]

Range("A1").End(xlDown).Offset(1,0).Select 'Next Blank Cell in column a

HTH

Die_Another_Day
Paulg wrote:
> I need some code that will allow me to select the first blank cell at
> the bottom of a column of numbers and calculate the sum. My problem is
> that each spreadsheet I import has a different number of rows, and I
> don't know how to select the number of rows specific to that
> spreadsheet from the blank cell at the bottom. My previous macros
> recorded the number of rows in the spreadsheet I recorded the macro
> in.
>
> Thanks
>
> Paul
>
>
> --
> Paulg
> ------------------------------------------------------------------------
> Paulg's Profile: http://www.excelforum.com/member.php...o&userid=36077
> View this thread: http://www.excelforum.com/showthread...hreadid=562060

[Paulg]

perfect! thanks