subscript out of range....
In that case, use this. Hope this helps! If so, let me know, click "YES"
below.
Sub AAA()
Dim sht As Long
Dim StartCol As Long
Dim EndCol As Long
Dim ColNdx As Long
StartCol = Range("A:A").Column ' column A
EndCol = Range("AB:AB").Column ' column AB
For sht = Sheets("apples").Index + 1 To Sheets.Count
For ColNdx = EndCol To StartCol Step -1
If Application.CountA(Sheets(sht).Columns(ColNdx)) = 1 Then
Sheets(sht).Columns(ColNdx).Delete
End If
Next ColNdx
Next sht
End Sub
--
Cheers,
Ryan
"J.W. Aldridge" wrote:
will actually be for each sheet after sheet "apples".
.
|