Loop that Deletes Rows

Hi guys,

I've tried executing this with normal excel functions, but it doesn't seem to work for me, so I'm hoping you all could help me out with a VBA code.

The goal is the run a loop on the values in AL:AV in the attached workbook. I'd like the code to search for the first number it finds and then clear the next 10 "days" or rows, then stop the code after it has cleared 10 rows, and again start searching for the next number in that column. As you can see, numbers are sporatically distributed in each column, so I can't just continously run a loop--it needs to be more specific.

Any ideas??

I'm clearing the contents of the 10 rows below the searched for number.

You got it

Hey

So the "point" is for AL2 to get deleted if AL1 is found. If AL1 is found, then AL2-AL10 should be deleted. But ONLY if AL1 found.

So for example, if you look at the sheet, the code should find that AL13 is populated with a number, and then clear AL14-AL23. Then stop the loop, and look for a number again. It should find a number in AL36, adn therefore clear AL37-AL46. WHen it runs the loop again, it will find a number in AL47, and do the same thing.

In regards to your other question, I think you mean do I want the values in, for example, AL47 cleared or the value in the Calc! sheet where it originated? I only want the values in AL47.

Thanks for the code. When I tried it, however, x = Round(Cells(l, i).Value, 3) had a mismatch

I have "headers" in AL 1 and 2. But I changed Range("AL1").Select to Range("AL13").Select so I figured that wouldn't be an issue. Maybe not...

Also, question, is this only applying to column AL? Becacuse the same idea should be applied to AL:AV, its just that the numbers are in different places so where the loop would stop and start will be different in each column

Hmm so it was able to run. But it ran on the values from Z:AV, and also cleared some numbers but didn't clear others. Did you try the code on the workbook I sent you? If you do, take a look at AL36 for example. Because there is a number there, AL37-AL46 should be cleared.

Okay now it's working on the right range.

These numbers are being taken from another sheet that is not attached to the workbook called "Calc!" I thought you were asking if I wanted the numbers on the Calc! sheet to also be cleared, which I do not. Could you clarify what you mean by "the value for it doesn't appear anywhere else"?

Okay I see. Let me be more clear.

It doesn't matter if the number exists anywhere else. It just matters if there's a number in that cell. "If AL1 is found, then AL2-AL10 should be deleted. But ONLY if AL1 found." I mean only if a number is found in AL1.

So for example, if you look at the sheet, the code should find that AL13 is populated with a number, and then clear AL14-AL23. Then stop the loop, and look for a number (i.e. any number) again. It should find a number in AL36, adn therefore clear AL37-AL46. WHen it runs the loop again, it will find a number in AL47, and do the same thing. It just matters if the cell has a value in it and is not blank

That worked perfectly in the workbook I sent you!! Thank you!

But when I try to use it in another workbook (with the ranges the same--AL:AV) it runs the code on Z:AV. Any idea why that happens?

It's exactly the same format as the workbook I sent you, except there are headers which are text

Oh nevermind, we're good.

Thanks so much for your help!!!