Recognize filtered records

[rover56]

Hello,
This is my question/problem. On my first worksheet I have a lot of records. Frequently I use the Autofilter to select a subset. After that I want a statistic summary of the filtered records. My macro goes from top to bottom and uses all of the records. How can I limit the macro tot the filtered records only? Thanks in advance....

Ron, Netherlands

 

[Bradium]

Try Advanced filter on another worksheet.


Details at

http://www.mrexcel.com/coolspreadsheets.html

Advanced Filter tip submitted by Brad Kennedy of Brisbane, Australia
Download: BradsFilterTip1.zip

Regards

Brad

 

[Weaver]

If your macro is working row by row, then you should test the .entirerow.visible property. If it's false, then you can ignore tha particular row in your calculations.

 

[rover56]

Thanks Brad & Weaver,

The last option (with the special cells) does the trick.

 

[shemayisroel]

http://www.mrexcel.com/coolspreadsheets.html

Great link - thanks!