I have a workbook that i am working on and trying to piece together a macro for it. I need a code that will delete entire row if cells in column D, E, and F are blank. I've tried a few that i found online but they either did not work properly or just took forever to run. Hoping you guys can help!!
Range of data on the sheet is Columns A through F and down to row 600.
Assuming column A is full (it will find the last row)
If column A is scatter shot and you are sure 600 is the max rows you will have
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Neil_; 09-28-2016 at 01:26 PM.
Frob first, tweak later
A slightly different approach:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Hi Olly
Cells in D, E and F may be blank at the bottom of the sheet, so the last few won't be filtered.With .Range("D1", .Cells(Rows.Count, "F").End(xlUp))
That doesn't matter. If there's something in them, then those rows wouldn't be deleted. If there's nothing in them, then they're just blank rows below the used range.Originally Posted by Neil_
Thanks Neil. Both work perfectly but i am sure will not have more than 600 rows so i used the second one. Saved the first one just incase it ever does go over.
Another possibility.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks