Hi Ya,
I've created this function that's supposed to return the number of a row in one sheet that has the value in it that's looked for in the sheet that has the UDF in it.
It works when I test it via a procedure, but it doesn't when I enter the UDF in a cell.
Any help would be greatly appreciated.
I've created this function that's supposed to return the number of a row in one sheet that has the value in it that's looked for in the sheet that has the UDF in it.
It works when I test it via a procedure, but it doesn't when I enter the UDF in a cell.
Any help would be greatly appreciated.
Code:
Function ConvertsDateToRow(DValue) As Variant
With Sheets("CLEAN_DATA_PER_DATE").Range("ca1:ca3084")
Set FoundDate = .Find(what:=DValue)
End With
ConvertsDateToRow = FoundDate.Row
End Function