try this:
Option Explicit Sub delTestT() Dim i As Long, c As Range Dim rng As Range Set rng = ActiveSheet.UsedRange For Each c In rng If InStr(c, "TEST TOTAL") > 0 Then c.Offset(0, 1).Delete c.Delete End If Next c End Sub
try this:
Option Explicit Sub delTestT() Dim i As Long, c As Range Dim rng As Range Set rng = ActiveSheet.UsedRange For Each c In rng If InStr(c, "TEST TOTAL") > 0 Then c.Offset(0, 1).Delete c.Delete End If Next c End Sub
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks