Ask Different is a question and answer site for power users of Apple hardware and software. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I was trying to run a Word macro on a Mac. That macro contains the split() function. When I run this it is throwing an error saying function or sub not defined.

StrArr = Split(InputString, ":", -1, vbTextCompare)

I searched on the Internet and found that Mac Word 2004 is supported by VBA 5 and split() is introduced in VBA 6 only. I'm unable to find the proper solution for this, please help me.

share|improve this question

Office for Mac 2004 is too old. You need to upgrade to Office 2011, which has the function you want:

Office for Mac 2011 comes with VBA 6.5, ported from Office for Windows. Source - Apple Store Q & A

(I'm assuming VBA 6.5 didn't remove the split() function from 6.0.)

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.