I want to delete the interior of the row above my selection. With the code I have, my selection is deleted (interior incl.) Bud only the first cellinterior of the row above is cleared.

Ex:
A1:A3 is colored red with text in the cell
B1:B3 is colored red with text in the cell.
--> I select B1:B3, hit my commandbutton delete, and B1:B3 is cleared and also is A1 (except the txt) A2 and A3 is still red. (The txt in A1:A3 must stay in the cells)

I want the cells A1:A3 also cleared of its interior. (not txt)

This is what I have fornow, any suggestions welcome (maybe need to DIM some, and point the range to the variable?)

Please Login or Register  to view this content.