did you declare a variable as Right or create a sub named Right.

--
Regards,
Tom Ogilvy

"Keivn Green" wrote in message
...
When I try to use this command in a macro to create a directory that is
the
last for digits of the activecell it says " Wrong number of arguments or
invalid property assignment."
Here is the line in the code..
MkDir ("C:\test\" & RIGHT(ActiveCell.Text, 4))

If the active cell says 12345678 teh it should make a directory called
c:\test\5678

Any ideas why this doesnt work?