code for sum of sht with diff # of rows

[Paulg]

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

Thanks

Pau

 

[Die_Another_Day]

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

HTH

Die_Another_Day

 

[Paulg]

perfect! thank