HSV
Inventaris
- Lid geworden
- 18 jul 2008
- Berichten
- 20.332
- Office versie
- Office 365
Code:
Sub hsv()
Dim area As Range, c As Range
Application.ScreenUpdating = False
For Each area In Sheets(1).Columns(1).SpecialCells(2).Areas
Set c = Sheets(1).Range(Split(area.Address, ":")(0))
If c.Row > 10 and Not Left(c, 1) = "-" Then
Sheets(2).Cells(Rows.Count, 1).End(xlUp).Offset(1).Resize(, area.Rows.Count) = Application.Transpose(area)
End If
Next area
End Sub
Laatst bewerkt: