Function Error: Compile error: Expected: list separator or )

Hi all,

Using Excel 2013.

My code is returning the error, not sure why?:

Compile error: Expected: list separator or )

Error here:

Please Login or Register  to view this content.

Calling this Function:

Please Login or Register  to view this content.

Thoughts?

thx
w

Please Login or Register  to view this content.

Thanks shg,

That works.

• Why vbLf as opposed to vbCrLf?
• Why is the "_" necessary at the beginning of the parameter list?

thx
w

1. Excel pretty much ignores carriage returns. For anything except writing output to a text file that requires the CR as part of the delimiter, line feed is sufficient.

2. Not necessary, just keeps the lines shorter, more readable, and therefore to me, more maintainable.

You were just missing a quote at the end of "... Warning"

Thanks shg,

Appreciate the explanations.
w

You're welcome.