How do I do a .ClearContents on merged cells from VBA? I need to programmatically delete values in merged cells but keep the formatting of the cells intact.
I get an error "Runtime Error 1004: Cannot change part of a merged cell." if I use .ClearContents on a merged cell.
Or do I just go for .Value = "" to delete whatever is in the cell?
Last edited by Bezzie; 02-02-2015 at 11:06 AM.
If A1:A3 is merged, try:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Thanks Mumps1. I use .Cells in stead of .Range but the .MergeArea idea still works. The following did the trick.
Please Login or Register to view this content.
My pleasure.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks