Thread: Cannot change part of a merged cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
happyPotter[_2_] happyPotter[_2_] is offline
external usenet poster
  
Posts: 1
Default Cannot change part of a merged cell

I've merged cells B22, C22, D22, E22, F22, G22 to give me 1 cell B22
Also merged B23, C23, D23, E23, F23, G23 to create B23 and this
continues to B31.

I'm trying to clear range B22 to B31 and I've put in this code

'Worksheets("Transfer").Range("B22:B31").ClearCont ents

I get the runtime error 1004 - cannot change part of a merged cell.
I'm able to get the code working on a cell that's not merged but not on
a merged cell. Any work around to this?


--
happyPotter
------------------------------------------------------------------------
happyPotter's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread...hreadid=384873

Reply With QuoteReply With Quote