LinkBack URL
About LinkBacks
How can I use VBA to delete rows that don't have content in column B(applying to rows 4 and below)?
Sorry, in the title I meant to say rows, not cells.
How can I use VBA to delete rows that don't have content in column B(applying to rows 4 and below)?
Sorry, in the title I meant to say rows, not cells.
Last edited by smith310; 02-13-2013 at 09:19 PM.
where r is the row number (index)
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
This did not work. An error came up.
Can you post a sample book??
Yes. Here it is. I really appreciate your help!
I hope I uploaded it correctly. What I want is for the rows that only have the time info to be removed.
HI Smith310. You can try this one. It will delete the complete row if there is any blank in row b4 and below. Hope i understood what you wanted correct.
SIncerely AbjacPlease Login or Register to view this content.
Last edited by abjac; 02-14-2013 at 12:21 AM.
Hi Smith,
Here's my code:
Please Login or Register to view this content.
Last edited by xladept; 02-14-2013 at 12:52 AM.
Thank you both so much! it worked!!!
You're welcome!
Thats good. Your welcome
Remember to set as "Solved"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks