Skip to content

Instantly share code, notes, and snippets.

View conzett's full-sized avatar
👋

Graham Conzett conzett

👋
View GitHub Profile
@conzett
conzett / macro.vb
Created December 21, 2011 21:01
ISSI APAK to Microsoft Dynamics GP GL Import conversion
Sub Remove1()
With ActiveSheet
.AutoFilterMode = False
With Range("a1", Range("a" & Rows.Count).End(xlUp))
.AutoFilter 1, "Source:*"
On Error Resume Next
.Offset(1).SpecialCells(12).EntireRow.Delete
End With
.AutoFilterMode = False
End With