LinkBack URL
About LinkBacks
EDIT: See post two below - changed the details of the problem.
EDIT: See post two below - changed the details of the problem.
Last edited by weldo; 10-02-2012 at 08:03 AM. Reason: First Edit: Problem changed. Second Edit: Solved.
It's better to use conditions (not color) to delete rows, if you know them attach a sample file for testing
If solved remember to mark Thread as solved
Fair enough, cheers for the reply.
I've attached some sample data. Basically, if the value in Column P is less than 0.5, I need the row to be deleted. I also need to ignore any row with a blank cell in Column P, so that if there is a blank cell the row doesn't delete.
Thanks again.
I have this so far, but cannot seem to get it to run. In the actual data, the range is from P3 to P2146. Any help is appreciated, thanks.
Please Login or Register to view this content.
Sorted it out, for anyone that's interested, I accidentally began the range at the top instead of the bottom, easy mistake! Updated code posted below (I also deleted the section of the code (from previous post) to not delete null values, the IsNull function, because these were to be deleted also, but blank cells were not deleted as desired due to the IsEmpty function).
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks