VBA select cell with a specific value and all cells below until blank

Originally Posted by Rick Rothstein

I am not sure how that affects the solution I posted but no problem, if hrlngrv's solution works for you then by all means use it.

To clarify, your one line of code did work. The number of rows did not affect your code. I just need to tweak it to include columns A through S. Thanks again for your help.