Application.Worksheetfunction metod

[tim201110]

Hi,
here post #23
i wanted to write a UDF without much pain.
There were formulas on the sheet.
I macro recorded them, changed links to variants, added formulas to Application.Worksheetfunction. Nothing
Excel did not understand Find, Search, Iferror, Mod, Mid and etc.
Here some of the above function are mentioned as canbe used.
Could you please put me in right direction?

PS What about using evaluate?

[shg]

Post what you tried that didn't work, Tim.

[tim201110]

Shg, I don't get what you mean. In the file everything works. doesn't it?

[shg]

I reckon I don't understand your question. What doesn't work that you think should work?

[tim201110]

in the file in D2:I2 there are formulas, which i wanted to use in UDF with minimum adjustments.
(if there is a working algorithm, why bother to make a new one?)
and Application.Worksheetfunction. my formulas don't work
debugger can not understand worksheet functions.
And i am curios how to work with Application.Worksheetfunction

[shg]

Tim, I don't see any VBA that uses Application.WorksheetFunction in that file.

[tim201110]

Me too
It refused to work
for example:
with autorecorder for D2
ActiveCell.FormulaR1C1 = "=--IFERROR(MID(RC[-3],1,SEARCH(CHAR(39),RC[-3])-1),)"
i changed it to:
s1= Application.Worksheetfunction.--IFERROR(MID(s,1,SEARCH(CHAR(39),s)-1),)
Debugger pointed out that i could not use Iferror and Mid this way.
And i wonder where i can find an instruction how to use Application.Worksheetfunction metod

[shg]

See, for example, https://msdn.microsoft.com/en-us/lib...ffice.14).aspx

[tim201110]

Shg, thanks!
But i'd like to see slightly different info: how to avoid restrictions of using worksheetfunctions in this method.