hi
A macro is required to delete rows with blank cells in columns D & E
The problem is the data is almost 900,000 rows
Sample data attached.
Cheers
Sam
hi
A macro is required to delete rows with blank cells in columns D & E
The problem is the data is almost 900,000 rows
Sample data attached.
Cheers
Sam
try
![]()
Please Login or Register to view this content.
It will delete rows whenever column D OR E is blank.
![]()
Please Login or Register to view this content.
Boon
This will work
![]()
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Thanks for everyone replied to this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks