VBA to delete cells without moving cells

**cmrluvitlevit** · 08-02-2010, 01:05 PM

I need to create a VBA code that will delete the contents of a cell without moving the cell location. I have tried the following code with the clear contents; however that does not satisfy the needs of the sheet that this information is going to. The only way I can make the cells truly clear is to press 'delete' in each cell. There is a long range of cells and this is taking way too much time. I could really use some help.

This is what I have, but it does not meet my needs.

For Each cell In Range("C7:R1006")
If cell = 0 Then cell.ClearContents
Next cell

Thanks

Chris

**Bob Phillips** · 08-02-2010, 01:59 PM

ClearContents is the same as Del as far as I can see.

**royUK** · 08-02-2010, 02:15 PM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here