| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting contents from merged cells from VBA
I have named 2 merged cells in a spreadsheet, say A1 & B1. The merged cell
is named "range1". I am trying to clear the contents from VBA code, using: Range("range1").ClearContents I get an error that says "Cannot change part of a merged cell" Is there a simple workaround? Assume I only know the range name and not the component cells. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete merged cells in Excel without deleting the final d | Excel Discussion (Misc queries) | |||
| row height increase automatically to fit contents of merged cells | Excel Discussion (Misc queries) | |||
| Clear Contents won't work on merged cells | Excel Programming | |||
| Clearing the Contents of Merged Cells | New Users to Excel | |||
| Clearing the contents of merged cells | Excel Programming | |||
Threaded Mode
