title: How to search data and return row number?
body: <p>I am trying to search x for example through a sheet of data. I thought of using Match function but match function only look up to only one column. x could be anywhere in that sheet, so is that any function or anything which can return the row number which can search all data? </p>
  
  <p>I have added codes in the excel and now the error of subscript out of range is appearing. I am not really sure if I did my find function correctly </p>
  
  <pre><code>Dim r As range 
  With Sheets("Sheet2").Range("A:DZU")
      Set r = .Find(What:="U1")
  End With
  </code></pre>