I ascertained that error 450 was because the cells that were merged were defined as Named Ranges only for one cell, rather than the entire range. Defining the Name as the full range fixed it. I did have some other issues around Validation, which had to be deleted and redefined. Thanks...