Autofilter Containing Text Criteria Not Updating Automatically

[asgharhussaini]

Hi!

I am new in vba. I want below code to work automatically but it don't until I click on any cell in the same sheet. Kindly help me solving this issue.

Kindly also suggest if i can transfer this code to commandbutton click event.

Thanks in advance,
Asghar

Please Login or Register  to view this content.