Clear Contents
Tom
DailyHours refers to a range of cells, within which there are merged cells.
Richard
"Tom Ogilvy" wrote:
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
|