Need Macro Code - Remove Duplicate

[wfmguy]

Need VBA code for Macro - to Run a "Remove Duplicate" for each and every column in the excel sheet (individually)

I have 190 Columns - Which have duplicate values in them. Need to remove Duplicate for Each Column individually


Eg
:

 

[Fluff]

How about

Sub RemoveDupes()
    
    Dim Rng As Range
    
    With ActiveSheet
      For Each Rng In .UsedRange
         Rng.Resize(.UsedRange.Rows.Count).RemoveDuplicates 1, xlYes
      Next Rng
    End With
End Sub

 

[wfmguy]

Thank you so much!

this is more than enough, however, can you please explain the login in this code?
Also any videos/books you can suggest for learning these codings

 

[Fluff]

Glad to help & thanks for the feedback

A fellow member, Hiker95, has put together a list of resources, which can be found here
https://www.mrexcel.com/forum/lounge-v-2-0/1031751-two-novice-questions.html

And finally I'm not sure what you mean by

can you please explain the login in this code?