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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.