Help with loop to select range of cells that meet criteria

Excel Gurus,

I understand the basic concept of loops in VBA but running into some issues. The value in Cell A1 is "*Department", Cells A4/A6/A8 are employee names, and in Cell A10 is "Total Sales". In Cell A13, will be another set of the same data for a different department with "Total Sales" in Cell A40. I need help with looping through data to select range (starting from row that contains "*Department", ending with row that contains "Total Sales), then displaying the address, before finding the next range. Any suggestions?

Please note that the number of rows between title and total row are not always the same. Furthermore, the data is organized in a format that will be copied into a powerpoint slide.

Thanks in advance!!

Forgot to mention that dataset extends thru Column E. Anyhow, I found my own answer. Hope this helps someone else.

Please Login or Register  to view this content.