NoSparks, hyou've hit the nail on the head. That new function is what I was looking for. I just ran some tests and it does just what I want it to do.

I know all that stuff happens in memory and it's hard to trace (one reason I asked for help). And I was testing the code changes against my database, which does contain punctuation: one of my searches was for a term, some of which occurrences had a preceding dash and some of which didn't. And by "extract", well, I always called the original macro "Extract_Rows_by_Text" because to me, I am searching for text, then copying it, then extracting it to a new workbook. Not JUST copying it. When one queries a database to produce a report, is that not called an extract? I never heard anyone wanting a report about data ask for a "copy", but for an "extract", yes!

Semantics aside, I greatly appreciate your help and patience with this task. It means a lot!