Forum Discussion
VBA Code: count & hide
When I select I6:N27 and click the button, only cells in that range are colored. Perhaps the cells in columns A, E and F had already been colored before.
I have corrected the coloring and the count (I hope). See the attached version.
Check out the attached version.
thank you man for your response, but there is a small issue that needs to be fixed
- the duplicate counting is counting all the duplicates in the table, I need only to count duplicates in column J
- if you could let the code not highlight the duplicates for columns ( A to H ) will be perfect ( as a fever) 🙂
Note: I attached the same file in your response
really appreciate your help, sir...
Which range do you select when you click the button?
the Range from columns ( i to n ), but still some points got highlighted ( A, E, F ) as the figure below :
if you could fix this, and the duplicate counting.. will be much appreciated
otherwise, it works really fine
Note: I attached the same file in your response
Thank you so much, sir
