Howdy again - appreciate all your help! I have a macro that takes data and then reformats it. Macro works great - at the end of it I would like to prompt the user (via Yes/No) whether they want to format additional data or end the macro. A "no" response would "END SUB" a "yes" response would take the user back to a certain pt in the macro. Is this possible? If not taking the user back to the beginning and rerunning the whole macro would be a second choice.

How would you do this?