Oct 11, 2016 · For object variables, you need to add the Set keyword, even in functions!. So just add that at the end : Function FindData(FindWhat As Variant) As Range Dim TheR As Range …

Feb 23, 2015 · Exactly as @barrowc commented. This works although not sure of exact requirements: Sub xxx() Dim value_to_find As String value_to_find = "fooBar" Dim r As Range …

Sub USING_FIND() 'this line sets the range to our used range on the active sheet With ActiveSheet.UsedRange 'setting c variable to .Find method, where the first value is what we're …

Mar 3, 2020 · The Range.Find method emulates the same window as when you type CTRL+F in Excel. Since you can't search for 2+ values at the same time in that window, I don't believe …

Jul 9, 2018 · I am learning about the Range.Find method. I have a column of letters (a to t) in column A of Excel, from row 1 to row 20. This code: Public Sub MyFind3() 'Accepts an input …

Aug 11, 2017 · Dates are tricky to find with the Range.Find method. One of the issues is that in VBA, dates are of the Date data type, but the worksheet does not have that data type. Rather …

Function find_in_two_ranges_two_sheets(ws1 As String, col1 As Integer) As Range Dim rows1 As Integer rows1 = Get_Rows_Generic(ws1, 1) Dim range1 As Range ' range of first search …

May 24, 2016 · A Listobject has several range properties you can use with Find: Range, DataBodyRange, HeaderRowRange (and InsertRowRange though that is an unlikely choice). …

Sep 14, 2017 · if you want to loop thru all the instances of the search arguments here is the correction of your code. Function picRng() As Range Set picRng = …

Feb 5, 2015 · Dim searchRng As Range: Set searchRng = Sheets("State Agent List").Range("C1:C10000") Dim r As Range Set r = …