Hide Duplicate Rows using Macro

Hello and Welcome to The Forum

Try this;

Please Login or Register  to view this content.

Another option:-
Place this code in ("ActiveX") command button as shown in code.
Click button to hide duplicate rows (based on first 4 columns)
Click button again to show hidden rows.

Please Login or Register  to view this content.

Regards Mick

Hi PaulSP8 and MickG,

Sorry lacking details.
For the table above, the data are auto generated by a software and
I wanted to run the macro automatically once workbook is opened.
Code should be placed in below.
Attachment 639289

PaulSP8,

The code works, but I need to manually run it.
How to automatically run it when workbook is opened?
I already tried placing the code in "ThisWorkbook" object.

You'd need to put the code in Workbook Open event, but to do that you'd need to open the Workbook, put in the code, close it (resaving as a macro enable file) and reopen it.

So, you might as well just run the code manually?

Alternatively you could add this something like this code to a button;

Please Login or Register  to view this content.

This would allow you to open the file and then run the hide macro on it.

Hi Paul, thank you.

How about if I want to check values from column F - S if all the same
with other rows?