it's a bit odd but i can't call a user-defined function i wrote when i try to do it from inside a sub/macro. those below wouldn't work, it's just a syntax problem i reckon:

ActiveCell.FormulaR1C1 = FindNth(A1:A200, "A", 1)
ActiveCell.FormulaR1C1 = FindNth("A1:A200", "A", 1)
etc.

i can call it from within a worksheet with

= FindNth(A1:A200, "A", 1)

when typing this into a cell.

but when i use it in the macro, the function is only available to that module and not to the worksheet the macro has been applied on....
For the same reason, i cannot use sth like

... = "=FindNth(A1:A200, "A", 1)"

Could somebody give me the right syntax (or tell me how to make a function from a macro globally available)

Cheers already

Fabalicious

I think you have to include the sheet name with it.

If you have defined the function in a Sheet or ThisWorkbook module try
putting it in a separate code mode. This seems to work !

MTB

It's a bear putting double-quotes inside strings, but I think this is what you want:

ActiveCell.FormulaR1C1 = "=FindNth(A1:A200, ""A"", 1)"
'note the double double-quotes around A