Clearing Merged Cells
Hi,
I have a range of cells that I need to clear before doing other stuff with them. These cells are formatted in a particular way and some of them are merged. I am trying to use: Sheets("mobilisation").Range("h2:n8").Clear but this is returning an error saying that Excel "cannnot change part of a merged cell" As I can both Clear and Delete the content of these cells manually, I assume that I haven't got the syntax correct to do it in VBA? Any help would be appreciated. TIA Dave |
Clearing Merged Cells
Try
Sheets("mobilisation").Range("h2:n8").MergeArea.Cl ear HTH, Barb Reinhardt "Risky Dave" wrote: Hi, I have a range of cells that I need to clear before doing other stuff with them. These cells are formatted in a particular way and some of them are merged. I am trying to use: Sheets("mobilisation").Range("h2:n8").Clear but this is returning an error saying that Excel "cannnot change part of a merged cell" As I can both Clear and Delete the content of these cells manually, I assume that I haven't got the syntax correct to do it in VBA? Any help would be appreciated. TIA Dave |
Clearing Merged Cells
Barb,
thanks for the reply. this now throws up: Run-time error 1004: Application-defined or object-defined error As you have probably guessed, I'm no programmer so I don't really understand what this is trying to tell me. Dave "Barb Reinhardt" wrote: Try Sheets("mobilisation").Range("h2:n8").MergeArea.Cl ear HTH, Barb Reinhardt "Risky Dave" wrote: Hi, I have a range of cells that I need to clear before doing other stuff with them. These cells are formatted in a particular way and some of them are merged. I am trying to use: Sheets("mobilisation").Range("h2:n8").Clear but this is returning an error saying that Excel "cannnot change part of a merged cell" As I can both Clear and Delete the content of these cells manually, I assume that I haven't got the syntax correct to do it in VBA? Any help would be appreciated. TIA Dave |
Clearing Merged Cells
Try this
Sheets("mobilisation").Range("h2:n8").MergeArea.Un merge "Risky Dave" wrote in message ... Barb, thanks for the reply. this now throws up: Run-time error 1004: Application-defined or object-defined error As you have probably guessed, I'm no programmer so I don't really understand what this is trying to tell me. Dave "Barb Reinhardt" wrote: Try Sheets("mobilisation").Range("h2:n8").MergeArea.Cl ear HTH, Barb Reinhardt "Risky Dave" wrote: Hi, I have a range of cells that I need to clear before doing other stuff with them. These cells are formatted in a particular way and some of them are merged. I am trying to use: Sheets("mobilisation").Range("h2:n8").Clear but this is returning an error saying that Excel "cannnot change part of a merged cell" As I can both Clear and Delete the content of these cells manually, I assume that I haven't got the syntax correct to do it in VBA? Any help would be appreciated. TIA Dave |
Clearing Merged Cells
I should have included that after the cells are unmerged, you can then clear
them. If you require merged cells in that range, then you will have to merge them again. Excel will not let you alter merged cells because it does not know which part of the cell you really want to change. You have to unmerge them, do your thing and then merge them again. "Risky Dave" wrote in message ... Barb, thanks for the reply. this now throws up: Run-time error 1004: Application-defined or object-defined error As you have probably guessed, I'm no programmer so I don't really understand what this is trying to tell me. Dave "Barb Reinhardt" wrote: Try Sheets("mobilisation").Range("h2:n8").MergeArea.Cl ear HTH, Barb Reinhardt "Risky Dave" wrote: Hi, I have a range of cells that I need to clear before doing other stuff with them. These cells are formatted in a particular way and some of them are merged. I am trying to use: Sheets("mobilisation").Range("h2:n8").Clear but this is returning an error saying that Excel "cannnot change part of a merged cell" As I can both Clear and Delete the content of these cells manually, I assume that I haven't got the syntax correct to do it in VBA? Any help would be appreciated. TIA Dave |
All times are GMT +1. The time now is 09:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com