Sorry, didn't know that.
The danger with events like Change and SelectionChange is that they occur very often. I always try to run the check as soon as possible in the event, use a button or set the macro to run every few minutes to keep the workbook running smooth.
I'm not sure the third...
Hi,
My name is Stefan. I've been playing with Excel and VBA for a number of years. For the last 2 years, i've made a number of Excel-programs for work.
I found Chandoo a couple of weeks ago and found it really helpfull. Now looking to contribute and once in a while ask a question.
Stefan