Dear bigme,
First of all, thanks for reaching out to the Exceldemy forum.
As you mentioned, your VBA code is doing nothing when you are running it from a button.
As seen from your VBA code, this code looks for duplicates in a column and then writes “Duplicate” if it finds one. I replicated the...