De rijhoogtes maakt hij allemaal gelijk terwijl ik bv de lichtblauwe juist dun wil houden. dus eigenlijk alle rijhoogtes zoals ze zijn overnemen.
Code:
Sub comprimerenrapportage()
Application.ScreenUpdating = False
Dim rapportage As Range
Dim bereik As Range
Set bereik = Worksheets("Gecomprimeerd").Range("B4:B14")
Set rapportage = Worksheets("Rapportage").Range("A1:G153")
Sheets("Gecomprimeerd").Activate
Columns("A:F").Select
Range("F1").Activate
Selection.ClearContents
With Selection.Interior
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End With
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
Selection.Borders(xlEdgeLeft).LineStyle = xlNone
Selection.Borders(xlEdgeTop).LineStyle = xlNone
Selection.Borders(xlEdgeBottom).LineStyle = xlNone
Selection.Borders(xlEdgeRight).LineStyle = xlNone
Selection.Borders(xlInsideVertical).LineStyle = xlNone
Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
Range("A1").Select
Worksheets("Rapportage").Activate
ActiveSheet.Range("$A$1:$G$153").AutoFilter Field:=7, Criteria1:="Ja"
rapportage.Select
Selection.Copy
Sheets("Gecomprimeerd").Activate
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Worksheets("Rapportage").Activate
rapportage.Select
Selection.Copy
Sheets("Gecomprimeerd").Activate
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Columns("A:F").EntireColumn.AutoFit
Sheets("Rapportage").Activate
ActiveSheet.Range("$A$1:$G$153").AutoFilter Field:=7
Application.ScreenUpdating = False
Sheets("Gecomprimeerd").Select
End Sub