Run macro automatically when a cell in a dynamic range changes
Hi Glimmer23,
been tring to get that for ages :) works as just hide -
but ill see if by change both to my hide if it speeds it up
Using 'MyHide' (instead of 'Hide') will not increase execution speed. It is
offered, purely as advice, to prevent VBA from being confused later when,
perhaps, your code becomes more complex and more difficult to debug.
As a general rule of thumb, it is adivisable to avoid the use of VBA
reserved words in any elective naming process.
---
Regards,
Norman
wrote in message
oups.com...
YOUR THE KING - been tring to get that for ages :) works as just hide -
but ill see if by change both to my hide if it speeds it up
thank you very much for your help
|