Dear Paul Sir,
This is fabulous work!
I think this must be flashing on the front page! :D. And I am Extremely
sorry for so late reply bcos of diwali vacation. I am VBA learner so only
basic knowledge of VBA coding.
I have some Question here:
1) Can I use this code in excel 2007 after giving ch
*Industrial Security Systems in Bangalore*
Security and police investigation Services AFL offers end-to-end security
system solutions together with securitystyle and consulting, product
management, remote observation and support and maintenance
http://www.busybizz.com/security-systems-bangal
the loop is checking all cells, regardless of whether they are visible or
not.So, you need to "test" to see if they are hidden.
In the loop, add:If (Not Rng.EntireRow.Hidden) Then
like:
If (Rng.Value = "Failed") Then
If (Not Rng.EntireRow.Hidden) Then
With Rng.Inter
