Excel is not reading

[rcprito]

Hello everyone,

I don't know why, but Excel is not reading my code.

It doesn't work when I play it normal, but it works When I read the code line to line.

Can someone help me?

The essencial part of the code is with the green colour.

Please Login or Register  to view this content.

Thanks a lot

[JasperD]

Try changing it to :

Please Login or Register  to view this content.

Please click the * below if this helps

[Norie]

Which worksheet is this supposed to clear cells on?

Please Login or Register  to view this content.

[rcprito]

thanks a lot

[rcprito]

Norie, it depends.

But imagine that is sheet 2. What should I do?

[Norie]

It might be sheet2, but only if that sheet is active.

If it's supposed to be clearing a range on a specific worksheet you should add a reference to that sheet as you've done throughout the rest of the code.

[rcprito]

But if I do Folha7.Range("AI3", Range("AI3").End(xlDown)).Clear it gives me an error.

The code JasperD wrote works fine.

[Norie]

The code in the original post will clear data on whatever sheet is active, as will Jaspers.

So if the right sheet is active then it will work.

To clear the right sheet even if it's not active you need to reference the sheet.

The code you just posted almost does that, but the 2nd Range doesn't have a worksheet reference so refers to teh active sheet.

This makes sure both Ranges have a worksheet reference.

Please Login or Register  to view this content.

[rcprito]

OK, let me see, but .clear is missing on that right?

Thanks!

[Norie]

That's just a typo, easily fixed.

Please Login or Register  to view this content.

[rcprito]

It's working, thanks a lot !