Syntax error in this program

[kathhying]

Please Login or Register  to view this content.

[tigeravatar]

kathhying,

You named a variable "name". Name is a built-in method in VBA used to rename a disk file, directory, or folder. So the variable "name" was getting confused with the VBA method Name. Change the variable "name" to "nam" or "nm" and you'll be fine

[jstephens]

Put "Option Explicit" at the top of your code and work with some of your variable names. I see the name array (which my excel didn't like for some reason), but I also see a Names array, Occur array, Numcust,

[jaslake]

Hi kathhying

What error message are you getting and at what line of code. I see

Please Login or Register  to view this content.

and then I see

Please Login or Register  to view this content.

which says

Please Login or Register  to view this content.

???????

[TMS]

As a statement of fact, your thread title is pretty accurate.

It probably would have been helpful to have explained where the problem was encountered.

As tigeravatar pointed out, name is a reserved word.

But, as jstephens has pointed out, there are one or two more errors in the code. Your naming is inconsistent and you use variables that you haven't defined. Option explicit will help you to identify them.

The code below runs but the Occurs variable needs to be defined and calculated.

Please Login or Register  to view this content.

Note that if you just press enter at the first InputBox, you'll get a blank MsgBox output.

Regards