You got me 99.% of the way there. without i = i-1 before the End If itwould skip consecutive zero rows.