Data from Power Query to excel table and the previous code does not work

[KaTa]

Hello,

previously, the data was not in table format and such code worked:

Sub Testl()
Dim x As Range
For Each x In Range("D2:D" & Cells(Rows.Count, "A").End(xlUp).Row)
        If x.Value = "" Then
        x.Value = "Wrong"
        End If
        Next
End Sub

Now the data comes as a table to Excel sheet via Power Query and the code mentioned above no longer works.
What should I change to make it work with the table too?

 

[RoryA]

That should work whether the data is in table format or not, though I can't see why you wouldn't just do it as part of the query.