used row count in worksheets to populate TOC

Hi,

I am designing a work book which runs several macros in order to generate work sheet names,insert headers,calculate totals and finally splitting the worksheets into several files. All modules are woking fine except where I need to do a count of used rows in each woksheet and append the totals in a table of contents. I have managed to generate the Table of contents with the worksheet names and the headings.The row totals for each worksheet and the Totals that is in colum E. I need help as how I will do a row count for each worksheet and append the total to the Table of contents Page

I'd have to see your table of contents to understand how to append the data, but you can determine the rows used by:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

I have uploaded the sample for your reference