Referencing a workbook using with

[BrianExcel]

Can you reference a workbook using the code

 With Workbook

for when you want to apply the code to all worksheets in a workbook? For example, when you have multiple lines of code you want to run for one userform or one sheet, it would be With Userform1 or With Sheets("SHEETNAMEHERE")

Can you do that with a workbook? Is there an easier way?

 

[dave3009]

You could use ThisWorkbook for the workbook containing the macro, or ActiveWorkbook for the currently active one. Or you can name a specific workbook Workbooks("WORKBOOKNAME")

 

[BrianExcel]

Thanks Dave.