Error when trying to protect sheet after exporting data to seperate workbook

Hi everyone,
I am getting a Run-Time error '9' on the last line of the following sub. Everything else seems to work fine. Basically, the sub's function is to unprotect the active sheet, copy the specified data, paste in a new workbook, then protect the sheet that the data was copied from.

I can't seem to find any threads related to this issue so any help is greatly appreciated.

Thanks,
Justin

Please Login or Register  to view this content.

Hi Amend the code as below.

Please Login or Register  to view this content.

Best
Rem0

Hi Rem0,
I revised the code as follows and am still getting the same error. Am I entering the code incorrectly?

Thanks,
Justin

Please Login or Register  to view this content.

Hi Venkatpvc,
I inserted the second line of code using variables and it worked flawlessly. Thank you for the response.

I reviewed the code and understand how the variables are created and used, however, am having a hard time grasping the advantage of variables.
Is there a brief explanation or resource that you could direct me to help me better understand? Thanks again.