Procedure too long

J

JessicaKinnear

New Member
Joined
Jan 6, 2021
Messages
25
Office Version
  1. 365
Platform
  1. Windows
Hello,

I have a code that was originally working fine, however now when I run it, I'm getting the error message that the procedure is too long. I've read that these could be shortened into smaller codes however my excel knowledge is basic so I'm unsure how to do this. Here is the code - thanks for any help in advance!

VBA Code: 
Sub Printtenant()
    Dim vShts As Variant

    vShts = Sheets("Set up & Print").Range("Z1")
    If Not IsNumeric(vShts) Then
        Exit Sub
    Else
        Select Case vShts
            Case 1
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
            Case 2
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
            Case 3
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
            Case 4
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
            Case 5
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
             Case 6
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
             Case 7
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
             Case 8
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
             Case 9
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
             Case 10
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
             Case 11
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
              Case 12
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
              Case 13
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
              Case 14
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
              Case 15
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
            Case 16
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
            Case 17
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
            Case 18
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
            Case 19
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
            Case 20
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
            Case 21
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
            Case 22
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 22", "Contacts")).PrintOut
            Case 23
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 22", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 23", "Contacts")).PrintOut
            Case 24
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 22", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 23", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 24", "Contacts")).PrintOut
            Case 25
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 22", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 23", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 24", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 25", "Contacts")).PrintOut
            Case 26
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 22", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 23", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 24", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 25", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 26", "Contacts")).PrintOut
            Case 27
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 22", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 23", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 24", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 25", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 26", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 27", "Contacts")).PrintOut
            Case 28
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 22", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 23", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 24", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 25", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 26", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 27", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 28", "Contacts")).PrintOut
            Case 29
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 22", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 23", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 24", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 25", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 26", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 27", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 28", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 29", "Contacts")).PrintOut
            Case 30
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 22", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 23", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 24", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 25", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 26", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 27", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 28", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 29", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 30", "Contacts")).PrintOut
            Case 31
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 22", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 23", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 24", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 25", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 26", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 27", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 28", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 29", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 30", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 31", "Contacts")).PrintOut
            Case 32
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 22", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 23", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 24", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 25", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 26", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 27", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 28", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 29", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 30", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 31", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 32", "Contacts")).PrintOut
            Case 33
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 22", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 23", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 24", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 25", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 26", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 27", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 28", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 29", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 30", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 31", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 32", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 33", "Contacts")).PrintOut
            Case 34
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 22", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 23", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 24", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 25", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 26", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 27", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 28", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 29", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 30", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 31", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 32", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 33", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 34", "Contacts")).PrintOut
            Case 35
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 22", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 23", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 24", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 25", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 26", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 27", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 28", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 29", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 30", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 31", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 32", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 33", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 34", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 35", "Contacts")).PrintOut
            Case 36
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 22", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 23", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 24", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 25", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 26", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 27", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 28", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 29", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 30", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 31", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 32", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 33", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 34", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 35", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 36", "Contacts")).PrintOut
            Case 37
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 22", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 23", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 24", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 25", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 26", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 27", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 28", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 29", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 30", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 31", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 32", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 33", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 34", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 35", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 36", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 37", "Contacts")).PrintOut
            Case 38
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 22", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 23", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 24", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 25", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 26", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 27", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 28", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 29", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 30", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 31", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 32", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 33", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 34", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 35", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 36", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 37", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 38", "Contacts")).PrintOut
            Case 39
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 22", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 23", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 24", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 25", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 26", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 27", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 28", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 29", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 30", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 31", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 32", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 33", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 34", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 35", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 36", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 37", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 38", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 39", "Contacts")).PrintOut
            Case 40
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 1", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 2", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 3", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 4", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 5", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 6", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 7", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 8", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 9", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 10", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 11", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 12", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 13", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 14", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 15", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 16", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 17", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 18", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 19", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 20", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 21", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 22", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 23", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 24", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 25", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 26", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 27", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 28", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 29", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 30", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 31", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 32", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 33", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 34", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 35", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 36", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 37", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 38", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 39", "Contacts")).PrintOut
                Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant 40", "Contacts")).PrintOut
        End Select
    End If
End Sub
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Sort by date Sort by votes
It looks like you can replace that with a loop:

VBA Code: 
Sub Printtenant()
    Dim vShts As Variant

    vShts = Sheets("Set up & Print").Range("Z1")
    If Not IsNumeric(vShts) Then
        Exit Sub
    Else
      Dim pageNum As Long
      For pageNum = 1 To vShts
        Sheets(Array("Cover", "Introduction", "Budget DETAILED", "Tenant " & pageNum, "Contacts")).PrintOut
      Next pageNum
    End If
End Sub
 
Upvote 0
Solution
Glad we could help. :)
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
X400 error code
Replies
1
Views
280
DanteAmor
DanteAmor
M
  • Solved
Highlight cell when a percentage amount has been met.
Replies
6
Views
123
Peter_SSs
Peter_SSs
C
  • Question
VBA Data Munging - deleting unwanted stuff
Replies
2
Views
346
Micron
M
Q
  • Question
Need to automate and redesign a file - Macro?
Replies
1
Views
399
OaklandJim
O
G
  • Solved
How to filter 2 Columns with the same text
Replies
9
Views
248
dreid1011
dreid1011

Forum statistics

Threads
1,215,234
Messages
6,123,776
Members
449,123
Latest member
StorageQueen24

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top