Hi all
I have a queation.
Let say i have a series of code... the code actually prompts the user to select the desired file, there are let say 5 files the user would need to chhose.
I am worried that the user may accidentally choose the wrong ones, and though the user KNOWS that he selected the wrong one, i guess the macro would continue formatting the wrong data and that would be not meaningful and waste of time.
I used to put On Error resume next. I know its wrong to put this because it simply carry on though there are errors.
I know there would be a line of code that the user can actually stop the whole macro?
Thanz alot!
Rdgs
James :spin: