Using advanced auto filter to choose all of range

[mendozati]

I have a formula that does almost everything I want it to, but I would like to to select the end right of the range and bottom of the range. When I record the macro, it shows the highlighted range (A3:P829), but I would like it to be a general formula instead because the bottom range may change aka there will be more rows of data. Here is the formula that is developed when recorded.

There are two worksheets I have used:
Baseline_Replacement
Replacement

Please Login or Register  to view this content.

[MarvinP]

Hi mendozati,

You need to learn this kind of code:

Please Login or Register  to view this content.

then in your Range("A3:P829") make it

Please Login or Register  to view this content.

If you need to find the last column in a row it looks like this

Please Login or Register  to view this content.

hope this helps.