Hi.
You should write something like :
If Ash.Columns("D").Cells.Value = "Yes" Then
For Each cell In
Ash.Columns("C").Cells.SpecialCells(xlCellTypeConstants)
...
Next cell
End if
Or
For Each cell In Ash.Columns("C").Cells.SpecialCells(xlCellTypeConstants)
On Sep 4, 12:23 am, mahesh parab wrote:
> Dear All
>
> i am getting caption error while runing the macro, i herewith attach sample
> sheet,I will greatly
> appreciate any help on this.
> Condition for if else statement
> If Column D value ="Yes"
> then Filter C column
> & copy the data
>
> Than
You have to always end the if statement
If Column D value ="Yes"
then Filter C column
& copy the data
End If
www.gate2quality.com/tools.html
On Thu, Sep 3, 2009 at 7:53 PM, mahesh parab wrote:
> Dear All
>
> i am getting caption error while runing the macro, i herewith attach sample
> sheet,I
