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