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.
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
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.
it's worked really well, just tiny issue is that the header of the columns disappears, if you could fix this, will be much appreciated.
thank you so much