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

Hi, Thanks for the reply, appreciate it..

Originally Posted by daffodil11

The code in the most recent workbook features a Worksheet_Change event, so all sheet references are implied to the sheet the code is imbedded on.....

.. I think I get that.. but this bit (In both your codes ) is still confusing me

.Range("A" & i, Sheets("Data").Range("M" & i))

Alan

...... accepting the bit about inmplicitly referencing the sheet in which the code is in, I would expect i t to look lkie this


Sheets("Data").Range(Sheets("Data").Range("A" & i), Sheets("Data").Range("M" & i)),

or if you were referencing the search sheet ( you are not ) then it would look like ( i thought)

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