set filter range value with other value (1 Viewer)

suryu

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

Can anyone help me with this?
 

Isaac

Lifelong Learner
Local time
Today, 01:49
Joined
Mar 14, 2017
Messages
8,738
Have you tried using the macro recorder to start out with? Then look at the resulting code ...
 

Isaac

Lifelong Learner
Local time
Today, 01:49
Joined
Mar 14, 2017
Messages
8,738
Wonderful. Glad you got it working.
 

Users who are viewing this thread

Top Bottom