vba -- autofilter 참고

vba  -- autofilter 참고

참고 ; 

http://www.ozgrid.com/VBA/autofilter-vba.htm

http://www.ozgrid.com/VBA/autofilter-vba-criteria.htm

http://www.ozgrid.com/VBA/autofilter-vba-dates.htm

http://www.contextures.com/xlautofilter03.html

https://blog.udemy.com/excel-vba-autofilter/

** AutoFilterMode -- drop-down 화살표 보이기 설정

https://msdn.microsoft.com/en-us/library/office/ff821903.aspx

 

** FilterMode  -- filter mode 인 경우 true . 즉,  사용중인 경우 true

https://msdn.microsoft.com/en-us/library/office/ff839763.aspx

- SE370: How to Filter and Copy in VBA

https://www.youtube.com/watch?v=BQSNEXSdpKU

- Copy auto filtered data to another worksheet automatically with VBA

https://www.youtube.com/watch?v=O21OCZ25d4A

- Excel VBA Add Autofilter Cancel AutoFilter sorting in worksheet

http://access-excel.tips/excel-vba-add-autofilter-cancel-autofilter-sorting-in-worksheet/