Advertisement
Guest User

Untitled

a guest
Feb 10th, 2016
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. Dim rngFound As Range
  2. Dim rngDel As Range
  3. Dim arrColumnNames() As Variant
  4. Dim varName As Variant
  5. Dim strFirst As String
  6.  
  7. arrColumnNames = Array("Hotel","India","Julliet")
  8.  
  9. For Each varName In arrColumnNames
  10. Set rngFound = Rows(1).Find(varName, Cells(1, Columns.Count), xlValues, xlPart)
  11. If Not rngFound Is Nothing Then
  12. strFirst = rngFound.Address
  13. Do
  14. If rngDel Is Nothing Then Set rngDel = rngFound Else Set rngDel = Union(rngDel, rngFound)
  15. Set rngFound = Rows(1).Find(varName, rngFound, xlValues, xlPart)
  16. Loop While rngFound.Address <> strFirst
  17. End If
  18. Next varName
  19.  
  20. If Not rngDel Is Nothing Then rngDel.EntireColumn.Delete
  21.  
  22. Set rngFound = Nothing
  23. Set rngDel = Nothing
  24. Erase arrColumnNames
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement