Need code edit..

[VBABEGINER]

What went wrong this code..?

For k = 2 To UsdRws 'UsdRws To 2 Step -1


If Cells(k, 1).Interior.Color = vbYellow Then
Rows(k).Copy Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1)
Rows(k).Delete
End If
Next k

 

[philwojo]

I am not sure the VBA can detect cells filled by conditional formatting, but maybe one of the other members knows for sure.

 

[steve the fish]

You would just test the cells in exactly the same manner as the test for if the cell should be conditionally formatted.