Hi Keivn,

Try dropping the outer parentheses.

MkDir "C:\test\" & RIGHT(ActiveCell.Text, 4)

worked for me.



---
Regards,
Norman



"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?