Hi,

Below is an extract from a macro, why do I get 'Subscript is out of range',
many thanks

Sub yy()

Dim curWkbk As Workbook

Set curWkbk = Workbooks("wip " & Format(Date, "dd-mm-yy") & ".xls")

End Sub