Option Explicit
Sub FUParm_RrintPDF()
Application.ScreenUpdating = False
Dim LastNummer As Integer
Dim LastCel As Range
Dim FileNamn As String
CreatesPdfFilenameToCellC1
LastNummer = Last(ActiveSheet.Columns("C:C")) 'variabel last deklarerad i >> Function Last(rng As Excel.Range) As Long
Cells(LastNummer, 9).Select
Application.ScreenUpdating = False
Set LastCel = Selection
ActiveSheet.PageSetup.PrintArea = "$B$2:" & LastCel.Address
ActiveSheet.Range("$B$7:" & LastCel.Address).AutoFilter Field:=4, Criteria1:=Array("Vecka"), Operator:=xlFilterValues
With ActiveSheet
.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\temp\" & "Vecka - " & Range("C1"), OpenAfterPublish:=False
End With
Application.ScreenUpdating = False
ActiveSheet.Range("$B$7:" & LastCel.Address).AutoFilter Field:=4, Criteria1:=Array("Vecka", "14 dagar"), Operator:=xlFilterValues
With ActiveSheet
.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\temp\" & "14 dagar - " & Range("C1"), OpenAfterPublish:=False
End With
Application.ScreenUpdating = False
ActiveSheet.Range("$B$7:" & LastCel.Address).AutoFilter Field:=4, Criteria1:=Array("Vecka", "14 dagar", "1 Mån"), Operator:=xlFilterValues
With ActiveSheet
.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\temp\" & "1 Mån - " & Range("C1"), OpenAfterPublish:=False
End With
Application.ScreenUpdating = False
ActiveSheet.Range("$B$7:" & LastCel.Address).AutoFilter Field:=4, Criteria1:=Array("Vecka", "14 dagar", "1 Mån", "3 Mån"), Operator:=xlFilterValues
With ActiveSheet
.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\temp\" & "3 Mån - " & Range("C1"), OpenAfterPublish:=False
End With
Application.ScreenUpdating = False
ActiveSheet.Range("$B$7:" & LastCel.Address).AutoFilter Field:=4, Criteria1:=Array("Vecka", "14 dagar", "1 Mån", "3 Mån", "6 Mån"), Operator:=xlFilterValues
With ActiveSheet
.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\temp\" & "6 Mån - " & Range("C1"), OpenAfterPublish:=False
End With
Application.ScreenUpdating = False
ActiveSheet.Range("$B$7:" & LastCel.Address).AutoFilter Field:=4, Criteria1:=Array("Vecka", "14 dagar", "1 Mån", "3 Mån", "6 Mån", "1 År"), Operator:=xlFilterValues
With ActiveSheet
.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\temp\" & "1 År - " & Range("C1"), OpenAfterPublish:=False
End With
Application.ScreenUpdating = False
ActiveSheet.Range("$B$2:" & LastCel.Address).AutoFilter Field:=4, Criteria1:="<>"
With ActiveSheet
.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\temp\" & "Fullständigt checklista - " & Range("C1"), OpenAfterPublish:=False
End With
Application.ScreenUpdating = False
End Sub |