I assume DailyHours refers to a single cell within a merged area - so try:

Range("DailyHours").MergeArea.ClearContents

which worked for me

--
Regards,
Tom Ogilvy


"Richard" wrote:

Why does the following not work on merged cells?

Range("DailyHours").ClearContents

When this does

Application.Goto Reference:="DailyHours"
Selection.ClearContents

I must be able to clear the contents of a range without selecting it, how?


Thanks for the help
Richard