Dynamic Autofilter range format

[kestefon]

Hi, Guys,

This should be a pretty quick/simple question. I recorded the following macro that adds an autofilter, sets a criteria, and sorts. I would just like to generalize the code and make it dynamic, because the number of rows may sometimes increase.

Could someone show me the proper format?

Please Login or Register  to view this content.

[HaHoBe]

Hi, kestefon,

if the data is limited by an empty column as well as an empty row you could use Range("A2").CurrentRegion for that. Untested:

Please Login or Register  to view this content.

Ciao,
Holger

[kestefon]

Thanks, Holger. That's what I'm looking for. By the way, I'm getting an "object required" error message for this part of the code...any ideas?

Please Login or Register  to view this content.

[HaHoBe]

Hi, kestefon,

certainly because the code hadnīt been tested before (neither is this). Try

Please Login or Register  to view this content.

as to the macro code the line belongs to the Sheet rather than the Range object.

Ciao,
Holger