Hello everyone,
I´m getting the error message of the title "Error 13 - Type Mismatch" at the first line of the loop.
Someone knows what it could be?Please Login or Register to view this content.
Hello everyone,
I´m getting the error message of the title "Error 13 - Type Mismatch" at the first line of the loop.
Someone knows what it could be?Please Login or Register to view this content.
Range(Cells(1,50), Cells(1,52)).Value is an array. = does not accept an array as one of its arguments.
As written it looks like you want the row deleted if all three cells ="" or if all three cells =0.
Do you want the cell deleted if one of the three =0 and the other two =""?
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Precisely what I want. Tnx.As written it looks like you want the row deleted if all three cells ="" or if all three cells =0.
I think there might be a flaw with your logic. But anyway, your code can be changed to
Please Login or Register to view this content.
I made the "dumb" way (writing cell per cell) and it worked now. Tnx
Try this. Note that when deleting, one should go from the bottom up.
Please Login or Register to view this content.
Tnk u friend, but why that?Note that when deleting, one should go from the bottom up.
I got it now... tnx
Consider the data
Adam
Adam
Betty
Adam
When i = 1, it sees "Adam" and deletes Row(1), making the dataPlease Login or Register to view this content.
Adam
Betty
Adam
and then goes on to i=2
Row(2) = "Betty" so it doesn't delete.
Row(3) gets deleted
Row(4) = "" and isn't deleted, leaving the data
Adam
Betty
It missed an "Adam" because it worked top to bottom.
Great tip. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks