|
If you want it to work for a range of cells or for any cell, then you would adjust the row and column tests accordingly. For it to work on all cells, you would remove the checking completely.I would like to apply this to a range of cells in one column (and for the purposes of this excercise, I am just testing the column and not a range of rows). It works great, except in the case when I select morethan one of the cells and press the Delete key to clear the contents. In this case, I get an error on the line "Target.Value =UCase(Target.Value)".
For it to handle cases where you are deleting contents, then you'd have to surround the UCase statement with the IsEmpty and IsNull checks.
Yes, the key is the EnableEvents method. If it blows up, the enable events status is still off, so the procedure will not fire again until it's either set back on or Excel is restarted.I guess I should say, it "worked" great. I can't get it to work anymore. Did it get "deactivated" when the error occurred?
Bill
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
