Applying Excel functions to arrays

[JYTS]

Hi everyone. I'm beginning to learn VBA and have a general question about it that I could not find the answer to through searching. How can I apply regular Excel functions to items in an array? Obviously this varies by the type, complexity, and arguments required for each function, but for example: If I have string array NeedsTrimmed and want to apply the TRIM() function to each item in the array, what's the syntax look like?

Thanks.

[protonLeah]

Access the elements of the array with a vartype Long and loop through the array:

Please Login or Register  to view this content.

[jindon]

Try

Please Login or Register  to view this content.

[JYTS]

Great, both of those answer my question. Thanks!