VBA Object variable or With block not set

[Strooprover]

Hi,

When I try this the red line gives the error: object variable or With block not set.
Can someone explain where I go wrong?

Thanks in advance!

Dim tabel As String


tabel = Range("A1").Value
For x = 1 To 1000


[COLOR=#ff0000]If ws2.Cells(x, 1) = tabel Then[/COLOR]
ws2.Cells(x, 1).Select


End If
Next x

 

[Nine Zero]

Hello,

Have you already defined "ws2"

I ran it like this and it works fine so im guessing its your declaration of ws2

Dim tabel As String

tabel = Range("A1").Value
For x = 1 To 1000

If Cells(x, 1) = tabel Then
Cells(x, 1).Select

End If
Next x