ou deleted column 1, then column 2 is now column 1.
> you increment your counter and check column 2.
> Which means that the "current" column 1 (formerly column 2) was never
> checked.
> If two adjacent columns happen to both have a "0", then you'll only delete
> the fir
1 0 1
when column C is deleted, the loop then checks column D
in the next iteration.
When deleting rows or columns, I prefer to work "backwards", like:
For ColNo = 750 To 1 Step -1
If Cells(1, ColNo).Value = 0 Then
Cells(1, ColNo).EntireColumn.Delete
End If
Next
hope this helps,
Paul
___
: Re: $$Excel-Macros$$ CODE DOESN'T WORK
thanks Daniel Ji for the reply... here what I need and what the code doesn't
do.
This code runs as long as the Sheets("1").Cells(2, ColNumber) =
Sheets("Name").Cells(RowCounter, 1) but doesn't do the job. I have some da
What is not working ? Do you get an error ?
>
> What are you trying to do ?
>
> Daniel
>
>
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* rakesh kumar
> *Envoyé :* dimanche 20 février 2011 11:16
> *À :* excel-macros@googlegrou
Hello,
What is not working ? Do you get an error ?
What are you trying to do ?
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de rakesh kumar
Envoyé : dimanche 20 février 2011 11:16
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ CODE
