Find start and Next row with text and create Cell Address in groups

I have a sheet with utilizes grouping, the rows in each group varies and the code I have is not dealing well with that

What I have is this

Please Login or Register  to view this content.

What I want to do is to have the C2:C200 be the actual address, this is setting the end to 200 and as I create more groups with rows
the number will reach well over 200, so then I have to go in an edit the code to reflect the additional rows and thats a pain.

So if there are 10 rows in that group then I would like it to be C2:C12
the next group will need to start at C13 and it may have 90 rows so the Address would be C13:C103

Is there anyway to create an index column to search for the next group?

Excelissue.jpg

To attach a Workbook
(please do not post pictures or links to worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"