PDA

View Full Version : VBA


SarahRecking
01-25-2017, 09:05 PM
What expression can be used to refer to the Workbooks collection?
p45cal
01-26-2017, 04:22 AM
Workbooks


Eg:
Sub eg()
For Each wb In Workbooks
Debug.Print wb.Name
Next
End Sub

or:
Set x = Workbooks