I am searching for the shortest syntax to modify this bit of code as follows;
"for any rows in the range between col e and 0, delete the entire row, EXCEPT col A, only if the the cells in that range are either 1 or zero...for any values graeter than 1, dont delet etc..
all input is most sincerely appreciated.
Please Login or Register to view this content.
Not sure I follow your criteria.Originally Posted by morbenforsen
Delete row if E:O has at one cell with 0 or 1, or all cells are 0 or 1 ?
Delete row except A? So delete B2:O2 if row 2 was to be deleted?
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
sorry let me try to clarify;
in cols E:O if the values in that range are greater than 1, I want to keep the row intact. If the values are 1 or 0 I want to delete all of that row..EXCEPT column A.
does that make more sense? thank you for your response!
more clarification: <<So delete B2:O2 if row 2 was to be deleted?>>
would prefer the whole row except col a.
edit; yes B2:02 would work for me in this case.
Last edited by morbenforsen; 01-06-2016 at 06:28 PM.
Let me try again: Is the criteria for All 11 Cells in a row or Any One Cell in a row.
Keep the row if all 11 cells are greater than one, or keep row if just one cell of the 11 is greater than one?
Last edited by AlphaFrog; 01-06-2016 at 06:32 PM.
My apologies. ALL Cells in range. "If any value other than 1 or 0 appears anywhere in that row, then don't delete..otherwise delete."
in B2:BO, DELETE IF:
there are ONLY 1's and 0's
OR if there are only 1's
OR if there are only 0's.
Here's one way...
Please Login or Register to view this content.
this seems to work...but Id' like to better understand what the Max function does in this case.
why does this not fail if you have a row that contains all zeroes except 2 cells which contain "1" in each cell...
help me understand this line exactly please?
Please Login or Register to view this content.
The Max function returns the maximum (largest) value of the cells. If the maximum value is less than two, then no cells are greater than one.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks