Thread: Clear Contents won't work on merged cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ArthurJ ArthurJ is offline
external usenet poster
  
Posts: 32
Default Clear Contents won't work on merged cells
I have merged cells C1 and D1, and named it 'mergedCells'.
But I get a "400" error from the following VBA code:

[mergedCells].ClearContents

That seems odd. Is there a workaround?

Art
Reply With QuoteReply With Quote