Welcome to VBAX Heet6498. Sorry but we are going to need a sample workbook to understand the logic of your issue. Are you able to attach one please? Click on Go advanced/ Manage attachments/Add Files/ChooseFile/Upload/Submit reply.