PDA

View Full Version : [SOLVED] Delete Cell w\o moving all other cells up



Djblois
08-07-2006, 12:46 PM
I am using a macro that if cell b1 is equal to a1 than I want it to delete b1. Then weather it does or not it goes to the next line. However, when it deletes the first line they all move up. How do I delete it without all the cells moving up?

Djblois
08-07-2006, 12:48 PM
Never mind I just figured it out. duh

Zack Barresse
08-07-2006, 12:48 PM
Instead of Delete use ClearContents, or to clear all data and formats, use Clear.

HTH