Writing code according to a model.

[Dave Neve]

Hi

The following line is taken from the help pages of VBA.

Join(sourcearray[, delimiter])

But in spite of it's simplicity, VBA will not accept my code (this happens a
lot to me)

Join(A[, " "])

A is my Array and the two " " have a space between them as delimiter.

What is wrong with such a simple line of code?

Thanks

 

[Alex Ivanov]

Dave,

Remove brackets[] and it should work.
In Help brackets ususlly mean that whatever is within is optional, in your
case
Join(A, " ") and Join(A) will produce the same result.

Alex.

 

[Peter Hewett]

Hi Dave Neve

When you see VBA code examples or documentation that uses "[]" square brackets
in this way it denotes an optional argument.

HTH + Cheers - Peter

Dave,

Remove brackets[] and it should work.
In Help brackets ususlly mean that whatever is within is optional, in your
case
Join(A, " ") and Join(A) will produce the same result.

Alex.

Hi

The following line is taken from the help pages of VBA.

Join(sourcearray[, delimiter])

But in spite of it's simplicity, VBA will not accept my code (this happens a
lot to me)

Join(A[, " "])

A is my Array and the two " " have a space between them as delimiter.

What is wrong with such a simple line of code?

Thanks