I have a simple vba code linked to a command button to clear a range of cells. I would like to add come coding to this to delete a certain shape in the same range of cells.
The shape is a: msoAutoShape
code:
Range("A4:S360").Select
Selection.SpecialCells(xlConstants).ClearContents
Range("A4").Select
I have formulas in this range, so that is why I'm using the this particular coding.
Any help would be most apprecaited!!!!
The shape is a: msoAutoShape
code:
Range("A4:S360").Select
Selection.SpecialCells(xlConstants).ClearContents
Range("A4").Select
I have formulas in this range, so that is why I'm using the this particular coding.
Any help would be most apprecaited!!!!