A quick description of what I want:Loop through a particular cell row and it's columns If any cell contains 0, then delete the entire column So let's say 4,4 was 0, then delete that column (D)My code works but takes a while Dim lColumn As LongDim iCntr As LonglColumn = 120For iCntr = lColumn To 4 Step -1If Cells(4, iCntr) = 0 ThenColumns(iCntr).DeleteEnd IfNextSurely there is a faster way to do this.
Looping through cells and deleting column
performance;vba;excel