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
|