Search Multiple Columns and Rows - Show results in Multiple columns and rows

Originally Posted by daffodil11

You certainly can use: Range(Range("a1"),Range(xx))

However, this works just as well: Range("a1",Range("xx")).

.....

.. Thanks I have learnt something there, .I did not know you could do that.

Alan

P.s. I think , though, the original problem is that the other code of yours were referrencing the search sheet and not the data sheet. ( - as you rightly said the code was in search sheet, so implicitly you were referrencing that ) ....Which you have corrected with

wsData.Range("A" & i, wsData.Range("M" & i))