Clearing Cells using a Macro and a button

[hsingh2088]

I've tried at least 4 or 5 different solutions on this forum and none of them have worked. I need to clear contents of cells within a range from rows 12 to 26, then rows 29 to 31 then 33 to 49 then 42 to 43 and columns E through N. I don't need any fancy coloring or anything like that, I just want to clear the contents of the cells. Can someone please show me the code for a sheet called "Summary?"

Thanks

 

[Jonmo1]

First (and preferred) method :
Don't use merged cells.
VBA and Merged Cells mix togeter about as well as Oil and Water.
A very similar effect to merged cells can be achieved with
"Center Accross Selection"
Found in the same window as merged cells, under "Text Alilgnment" Horizontal


Second method...
Only the Top Left Cell of the merged range actually contains any data...
So you only need to refer to the top left cell of the merged range...
So if the Merged Range is A1:D10, then you would only write
Range("A1").ClearContents.


Hope that helps.

 

[HalfAce]

Sorry I never got back to this yesterday, (work getting in the way of life again), but after your first response to our posts I was wondering if merged cells were going to be the culprit.

Jonmo's right. As far as VBA is concerned, "merged cells is the devil."