How to delete data from Non colored/Highlights Cell from excel?

[yashsrawat]

Hi There

I am working on big excel , where i have highlighted few cell where which need to be uploaded and rest of data which in non Highlighted should be deleted.
This Data has 300 Column and 10000 Rows

Any help how to delete the data from non highlighted cells.

 

[Trevor G]

Why not copy/paste the highlighted cells to another sheet no need to delete. Are they manual highlighted or is CF involved?

 

[yashsrawat]

These cells manually highlighted and i want cells which are non colored from them all data should be deleted.

 

[Trevor G]

If you only want to clear the cell content then try this.

Sub clearCells()
Dim cell As Range
For Each cell In Selection
    If cell.Interior.Pattern = xlNone Then
    cell.Value = ""
    End If
    Next cell
End Sub