copy and check sheets in one action

[cocopops2001]

what i want to do is copy a sheet into a user workbook from a masterworkbook but to check if a cover sheet exists first.

here is a breakdown of the process.

user opens 'master workbook' and decides which sheet they want to copy (clicks copy button)

opens user workbook or creates new workbook(if this can be done in the same directory as the 'master' or even allow the user to decide which folder)

checks if the 'user workbook' has specific cover sheet(check if sheet1, cell A1 has "title" in it) if the cover sheet exist paste in desired sheet, if not create cover sheet then paste desired sheet. it is important that the cover sheet is put in sheet1 of the 'user workbook'

what i would like is a way for the macro to remember which sheet from the 'master' is to be copied. i am currently using

ActiveSheet.Range("a11:n70").Copy

the problem is that when the macro does the covercheck and has to copy/paste 'cover sheet' into new workbook the clipboard will clear and the desired sheet will not be copied.

thanks

 

[cocopops2001]

solved this problem now, just needed to take a step back and do some rearranging of my code but thanks for the input