Formatting all sheets within a workbook?

[Zaichik123]

I've tried doing this via a With ActiveSheet.PageSetup and then selecting all sheets to run the macro on - and also With ActiveWorkBook.PageSetup but still to no avail.

Predominantly I want to PrintTitleRows across all sheets within a workbook - is this possible? Whats the code for this?

Z123

 

[VBAjedi]

Not sure exactly what code you're trying to run on each sheet, but you can loop through all the sheets using something like:

Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
   ws.PageSetup ' do whatever here
Next ws

Let me know if that's what you are after!

VBAjedi