Hello once again.

I have a named range which is populated by a userform, so I would like to clear all cells in the range before re-populating them each time. This is straightforward, and of course fails with merged cells in the range.

Name of the range is "TemplateData", located on Sheet1.

Solutions? Aside from getting rid of the merged cells, as much as I would like to. Clearing them individually would be painful.