In what way does it not work?

Maybe you can provide detail of the range, DailyHours. What cells does it
include?
Which of the cells in the range are merged.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Richard" wrote in message
...
Andy

thanks for the idea, doesn't seems to work

Cheers
Richard

"Andy Pope" wrote:

Hi,

Try this,

range("DailyHours").MergeArea.clearcontents

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Richard" wrote in message
...
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