View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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