i am trying to find repeated values in the column if found it become marked color(yellow)
but it is only searching single repeated value
please help
i have attached my file
this macro code
![]()
Please Login or Register to view this content.
i am trying to find repeated values in the column if found it become marked color(yellow)
but it is only searching single repeated value
please help
i have attached my file
this macro code
![]()
Please Login or Register to view this content.
That work only after active cell.
This will work for all range you select.
Select range and run SER2
![]()
Please Login or Register to view this content.
Last edited by zbor; 10-11-2014 at 06:28 AM.
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks