Problem using optional aguments on sub
Help! I am writing a sub like this:
Sub nextSection(Optional workbookPath As Variant, sheetName As String, cellRef As String, waitSeconds As Integer)
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?
Business Intelligence Analyst