Hi all,
I have a code that produces a mssg box if any "P" value is selected (data validation) in column A. The mssg box allows the user to specify how many additional lines they need to add, and adds them by copying the line x number of times. However, I often encounter a run-time error that completely freezes excel and forces me to quit excel via task manager. Is there and if error code I could tie around this?
Any help would be greatly appreciated.
As you can see, I tried implementing my own if error code but it did not work. I still ran into the problem of excel shutting down.
Bookmarks