Welcome to the forum. Just from reading the title I would make one suggestion - find an alternative to Merged Cells - they will make coding a solution more difficult.