Resetting ActiveSheet.Range macro

[drrazor]

Hi,
I've got one probably simple problem, but can't think of any solution, I used following macro:

Please Login or Register  to view this content.

but now the range I wan't to operate on has been changed to D1:Z1500, changing range values in macro doesn't change a thing, how can I reset it without creating new worksheet and copying the data, and making new macro.

Thanks in advance!

[alansidman]

Try this:

Please Login or Register  to view this content.

[drrazor]

nope, it throws back me an error 1004.

[alansidman]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Richard Buttrey]

What do you mean by 'doesn't change a thing'?

Are you saying that the macro runs but doesn't filter any 'blas'?
If so are you sure that there are some blas in the E1:E1500 range?

[drrazor]

Ok here's what I do, for example, I use macro:

Please Login or Register  to view this content.

and here's the result:
Untitled0.png

than I reset the macro with another one:

Please Login or Register  to view this content.

And when I change range in the first one to:

Please Login or Register  to view this content.

The result is exactly the same as it has been recorded in the first time:
Untitled0.png

And yes, there are many blas in range D1:AD1000.

[alansidman]

Pictures don't help us to help you. We cannot see all the data. Please upload a sample workbook so that it can be analyzed. Which line was highlighted in your code when you ran debug and what did the error message say beyond the error number. When you upload your workbook, be sure to include your entire VBA code, especially the one that seems to fail so that it can be examined for correctness.

[Kaper]

Why do you expect any difference? Data ends at row 1233.
Have you really posted two different pictures? - both have the same name.
Last but not least - czy nie widzisz różnicy między "obrazek" a "sample workbook"?

[drrazor]

Here's the example. The rectangle selects cells in range D1:AD1800 containing bla in 3rd column from the beginning of the macro. And Oval clears the selection.

I already changed the selection in VBA for the desirable D1000:AD1800, but macro still records D1:AD1800, and throws me back that as a result.

[Kaper]

use:

Please Login or Register  to view this content.

instead