newatmacros
New Member
- Joined
- Jun 23, 2016
- Messages
- 18
I have been exhausting myself trying to appropriately create a macro that delete entire rows in my worksheet A2:LastRow of data based on certain criteria
I have been working on creating a macro that deletes entire rows of all data if anywhere in the row there is a blank cell. Unfortunately, the ones that I have created always come up in an error due to overlapping with some rows containing more than one blank cells. I also need to add to this formula to delete rows if it has an error formula. Again, I encountered the same error with creating this as well.
One macro for both of these commands is ideal.
Any help will be greatly appreciated!
Thanks!
I have been working on creating a macro that deletes entire rows of all data if anywhere in the row there is a blank cell. Unfortunately, the ones that I have created always come up in an error due to overlapping with some rows containing more than one blank cells. I also need to add to this formula to delete rows if it has an error formula. Again, I encountered the same error with creating this as well.
One macro for both of these commands is ideal.
Any help will be greatly appreciated!
Thanks!