Thread: code for sum of sht with diff # of rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paulg[_7_] Paulg[_7_] is offline
external usenet poster
  
Posts: 1
Default code for sum of sht with diff # of rows

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

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

Reply With QuoteReply With Quote