Hi,
Anyone see why this code won't work? I want to delete rows with blank cells in column 'X'.
Any help would be much appreciated.
Please Login or Register to view this content.
Hi,
Anyone see why this code won't work? I want to delete rows with blank cells in column 'X'.
Any help would be much appreciated.
Please Login or Register to view this content.
Last edited by Ardiko; 09-19-2012 at 10:23 AM.
Try this
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.
Another way
Please Login or Register to view this content.
Try this instead...
There were too many logic errors in your code to simply patch it.Please Login or Register to view this content.
For example:
Cells(xrow,1) is looking at Column A not Column X
Do Until Xrow = xlastrow wouldn't ever get there as you were subracting 1 from xrow
xrow would go negative as soon as you found the first blank in your A columns....
Too many errors in logic......
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi mike,
You line of :
If Cells(xrow, 1).Value = "" Then
looks at column A not X.
Sorry I missed column X update to code
Please Login or Register to view this content.
Hi - I'm very bad at coding which line do I change for it to do column 'X' and at a specific row.
e.g. I want it to delete all rows in column 'X' with a blank so when I filter this is typically less than a 100 but could be the 50th row value to delete or the 1000th value to delete.
Hi guys,
I still haven't solved this problem. I've attached a demo file of what I need done.
I just need the blanks gone but I can't solve debug the issue from the previous solutions.
Any help would be greatly appreciated.
Delete Blanks Cells.xlsm
Try this should work
Please Login or Register to view this content.
Thanks Mike, I realised that by adding an extra column it had got pushed to Y without me knowing.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks