shiv_379

Help! I am writing a sub like this:

Sub nextSection(Optional workbookPath As Variant, sheetName As String, cellRef As String, waitSeconds As Integer)
....
End Sub

But it keeps popping up with an error and telling me it expects sheetName to be option. It keeps this up with each one until I've declared everything optional!
Does anyone know what might be going on here?

-Shiv

shiv_379

Ahh...someone has solved it for me. The Optional argument has to be last in the list.

Sorry!

Jamirez

Not the last, but everything that comes after a Optional parameter has to be Optional.