I'm using the following code to switch the entry of a cell to upper case and change the formatting based on its contents:
This works wonderfully, until I drag to fill multiple cells, then it throws an error and I have to close excel completely and re-open before it will work at all.
Please Login or Register to view this content.
I want to be able to drag to fill without crashing the code, any ideas?
Also, any ideas how to apply this to cells that are already filled? This only works if I change the contents of the cell, which is great going forward, but I'd like to apply it to existing data.
nevermind this part, I used the following :
Please Login or Register to view this content.
Last edited by Overlord; 09-23-2009 at 06:51 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks