if the value in the cell is null (or different from a determinate value)

[pulsarXX]

Hi,

You will find joined a sheet with a macro I wrote. The thing is I want to test if the value in the cell is null (or different from a determinate value) and I am looking for the logic sign that means 'different from'. In other programs I used it usually was '!=" but here it does not seem to work.
I would be very grateful if you had any idea about how to deal with that.

Thank you very much,
Gulgun

 

[Ömer]

Hi,

Sub example()
Range("B2:B65536").ClearContents
For counter = 2 To [A65536].End(3).Row
    With Worksheets("Feuil1")
        If .Cells(counter, 1) = 0 Or .Cells(counter, 1) = "" Then
            .Cells(counter, 2) = "Non nul"
        End If
    End With
Next counter
End Sub

Is this what you want?

.

 

[halit3]

ömer bey

Range("B2:B665536").ClearContents

yukarıdaki kodda bir tane 6 sayısı fazla galiba

More than six number one in the code above, I think

Range("B2:B65536").ClearContents

 

[Ömer]

Haklısınız. Düzelttim Halit Bey, teşekkürler..

.

 

[uzmanamele]

hi

ecnebicemiz Türkçe mi? :lol:

 

[pulsarXX]

Cok tesekkurler yardimlariniz icin!