View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mikerobe mikerobe is offline
external usenet poster
 
Posts: 27
Default Count of Worksheet rows and recording this count

Hi,
I have data in a Worksheet (Sheet1) in Columns A and B, the number of
rows of data is variable. The first and last row of data is a header
and footer. I need to count the rows in between the header and footer
(not counting the header and footer rows) and place this count (same
number) in the header row and footer row in Coulum C. For example the
count in the header row would be placed in cell C1 and the count in
the footer is in cell CX (x being a variable)

I hope this is clear

Thanks for any help
Mike