Clear cells which seems that are blank

[Panoos64]

Hi to all of you, I would like to use a VBA code so that to clear any cells which seems that are blank but actually are NOT (blank). Therefore that the columns begin from "D6" : "AW100000 and i use the command "Filter / blanks Cells" then ""clear" which i assigned into macro, but due to lot of columns, is too slow. I would much appreciate any support. Thank you all in advance.

 

[Fluff]

Maybe

Sub panoos()
   Dim Usdrws As Long
   
   Usdrws = Range("D:AW").Find("*", , xlValues, , xlByRows, xlPrevious, , , False).Row
   With Range("D6:AW" & Usdrws)
      .Value = .Value
   End With
End Sub

 

[Panoos64]

Thank you Fluff, is very kind of you to spent your time for my project. It works nicely. Hv a great, lovely day!

 

[Fluff]

You're welcome & thanks for the feedback.