I am trying to pass xlvalues, xlwhole, xlbyrows but I am getting an error msg (byref) when I try to compile this. I have the values that I am trying to pass, come from a table that stores the values.
My error is happening at this line:
Set ResultRange = FindAll(iRange, kWord, p3, p4, p5, p6)...