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