set filter range value with other value (1 Viewer)

suryu

Member
Local time
Today, 17:50
Joined
Apr 3, 2020
Messages
54
I want to set Range("E") of excel after filter with values "Duplicate" using vba

Can anyone help me with this?
 

Isaac

Well-known member
Local time
Today, 05:20
Joined
Mar 14, 2017
Messages
1,037
Have you tried using the macro recorder to start out with? Then look at the resulting code ...
 

Isaac

Well-known member
Local time
Today, 05:20
Joined
Mar 14, 2017
Messages
1,037
Wonderful. Glad you got it working.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom