VBA to update Dynamic Range in filter

[shiva_reshs]

Hello,

I have below VBA code which I recorded in order to do the selection of filter value.

Please Login or Register  to view this content.

But how can I make range in above code to be dynamic? Because every time data would be different so range would wary..
please assist.

Thanks,
Shiva

[AlphaFrog]

There are a couple of methods. Here is one...

Please Login or Register  to view this content.

[shiva_reshs]

Can this also work for sub total addition?

Please Login or Register  to view this content.

[AlphaFrog]

It could depending on the nature of your data.

Use .SetRange Range("A1").CurrentRegion and change the .Header = xlYes

You're welcome.

[shiva_reshs]

works well..

Thanks