VBA to Reset Autofilter and UNselect specific numbers

[woolen]

Hello! I already have vba that selects a range from Worksheet named "Datos" and pastes it in a worksheet named "Specific Data". This pasted data is then used to automatically make a graph. The problem is that the range changes each time new data is pasted.

What I need: I need to add to the VBA below so that once the data is pasted in the worksheet "Specific Data", a filter will be reset for Column I only (reset the filter to everything selected), and then always UNSELECT the numbers 0 and $0, that appear in column I.

Please help, and thank you in advance!!

Please Login or Register  to view this content.

[asyahfuddin]

I have the same problem about that, please help him