Attached is a spreadsheet where column A has data.
How do I code a macro to delete an entire row is everything after column A is blank?
Attached is a spreadsheet where column A has data.
How do I code a macro to delete an entire row is everything after column A is blank?
Hi dagindi, I'm not entirely sure about what it is you want here. You want to delete a row if every cell in the row is blank after column A? What if column ....AJ, has data in it, you would keep that then?
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
As a note, some of the rows with the text in column A highlighted red did indeed have data in the row in another column (for example, Austria, Azerbaijan, etc.![]()
Please Login or Register to view this content.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks