Clear Contents

[Guest]

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

 

[Andy Pope]

Hi,

Try this,

range("DailyHours").MergeArea.clearcontents

Cheers
Andy

 

[Guest]

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

Range("DailyHours").MergeArea.ClearContents

which worked for me

 

[Guest]

Tom

DailyHours refers to a range of cells, within which there are merged cells.

Richard

 

[Guest]

Andy

thanks for the idea, doesn't seems to work

Cheers
Richard

 

[Andy Pope]

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