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?
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?
Never mind I just figured it out. duh
Instead of Delete use ClearContents, or to clear all data and formats, use Clear.
HTH
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables