I want to search for text in column E, when I find the first cell containing text I want to set that cell and then search for the next cell containg text. When that is found I want to select and copy that entire range. For example column E would have some text eg. "start" then the next several cells might be blank until the 8th one might say "end". I want to select and copy from column A to column E in that "start" to "end" range and then contiue searching for the next "start" to "end" range, contiue to search as long as column A cell value is not empty.

Thanks

Jim