Dynamic Filter

Hi,

I am new to VBA and have recorded a macro.

I am applying a filter to a data set and want the range selection to by dynamic for the filter (it adapts to the changing data). My the code right now I have in VBA is a follows, which is from my understanding just selecting cells up to 31706.

What should I change in the code so that it selects the data dynamically?

Please Login or Register  to view this content.