View Single Post
  #2 (permalink)  
Old July 29th, 2007, 04:52 PM
robzyc robzyc is offline
Friend of Wrox
 
Join Date: Mar 2007
Location: Hampshire, United Kingdom.
Posts: 432
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hans,

"Argument Not Optional" error is normally thrown when a method requires parameters.

Are you sure there are no parameters for the AllocateLinks Sub??

I am also assuming "wsTurns" is an actual Worksheet, not Worksheets (Collection) Object??
If it is actually a Worksheets Object, then this may cause the error.

Regards,
Rob

<center>"Nothing can stop the man with the right mental attitude from achieving his goal;
nothing on earth can help the man with the wrong mental attitude".

Thomas Jefferson</center>
Reply With Quote