var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: syntax problem / function call in sub
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)
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)
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 !
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