Re: $$Excel-Macros$$ What will be the best code to count the number of visible rows after autofilter.

2015-03-21 Thread Mandeep baluja
HEY EUgene, not giving correct result let me explain it to you why, Try these three example firrst in filter unselect first four option you will see correct result. Another one unselect lasst four option yes it works, Another one unselect all select middle some values yes it work,s now th

$$Excel-Macros$$ Database for concert ticket sales

2015-03-21 Thread ldenholl
Hi all, I'm an intermediate Excel/Access user and have an inquiry for you all. You know how when you buy tickets for a big event online and you can select which seats you want in the process of buying? That's what I'm looking to do. I'm looking to set up a database/excel sheet that tracks tick

Re: $$Excel-Macros$$ What will be the best code to count the number of visible rows after autofilter.

2015-03-21 Thread Eugene Bernard
Hi Mandeep, Just check the attached example. Regards Eugene On Fri, Mar 20, 2015 at 11:59 PM, Mandeep Baluja wrote: > Hey Eugene,,not easy as you're thinking > > This code will not give the correct result end -start +1 will never be > equal to no of hide rows with filter, because these variabl