Argument not Optional

aziaraphale · July 29th, 2007, 02:50 PM

Hi all,

I am fairly new to VBA and have the following problem:

I have the following sub:

Code:

Public Sub AllocateLinks()
    ...
End Bub

This routing is part of the worksheet wsTurns and I call it as:

Code:

Private Sub btnAssignSections_Click()
    wsTurns.AllocateLinks
End Sub

This however causes an Argument not Optional error message which I do not understand.

Thanks for all help,

Hans

robzyc · July 29th, 2007, 04:52 PM

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>

aziaraphale · July 30th, 2007, 04:18 PM

I am sure there is no argument required by the function. wsTurns is a worksheet object not a collection.

Cheers,

Az.

robzyc · July 31st, 2007, 03:40 AM

Does the error occur at compilation or run-time?

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>

aziaraphale · August 1st, 2007, 12:49 AM

The problem occurs at run time.

Cheers,

Az

robzyc · August 1st, 2007, 02:53 AM

What line does the error occur on?? Step through the program at run time to see where it falls over.

When you find the line that is causing the problem. Examine each of the objects to see where it is going wrong.

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>