Selasa, 09 Juni 2015

Re: [ExcelVBA] Re: Auto Filter Help

 



It's easy enough to turn autofilters off and then on again.  This will at least save some work.
 
What will take the effort is capturing and reimposing the criteria active at the time.  However, I do think it's doable in VBA, if you have a bit of time to spend on it.

Regards, Dave S
 
----- Original Message -----
Sent: Wednesday, June 10, 2015 10:43 AM
Subject: [ExcelVBA] Re: Auto Filter Help

Well, I appreciate the help everyone, but it may be impossible in VBA.  I'll keep searching the net in hopes of finding something.  It's not a big deal, the filter I usually have on is for two columns, and it's not TOO big a deal to have to turn them back on afterwards, just breaks the flow of data entry.

Scott

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2015.0.5961 / Virus Database: 4355/9985 - Release Date: 06/09/15

__._,_.___

Posted by: "David Smart" <smartware.consulting@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (7)
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

.

__,_._,___

Tidak ada komentar:

Poskan Komentar