Macro Error Detection

Hello!
I have an existing macro that copies a range of data to another worksheet. I have an error code to determine if the destination worksheet exists.
I also want to make sure that the destination range is empty before I copy to it. If the range is not empty I want to display a message box stating this fact and exit the macro.
Note: cell P13 contains a number that determines which worksheet to copy the range to. For example: if P13=2 the range is copied to worksheet "Week2" - Range ("A5").
This is my existing macro:
Thanks for your help!

Please Login or Register  to view this content.

This worked great!
Thanks so much!