Re: $$Excel-Macros$$ Finding Start and End visible Row numbers

2015-03-09 Thread Vaibhav Joshi
Use above code in conjunction with auto-filter code. On Sun, Mar 8, 2015 at 4:22 PM, Eugene Bernard wrote: > > Dear Vaibhav, > > When I hit the button, I am getting the below error. > > [image: Inline image 1] > Regards > Eugene > > > On Sat, Mar 7, 2015 at 4:00 PM, Vaibhav Joshi wrote: > >> Ch

Re: $$Excel-Macros$$ Finding Start and End visible Row numbers

2015-03-08 Thread Eugene Bernard
Dear Vaibhav, When I hit the button, I am getting the below error. [image: Inline image 1] Regards Eugene On Sat, Mar 7, 2015 at 4:00 PM, Vaibhav Joshi wrote: > Check this.. > > Cheers!! > > On Fri, Mar 6, 2015 at 5:04 PM, Ashish Kumar > wrote: > >> Hi Eugene, >> >> >> PFA, Filter your data t

Re: $$Excel-Macros$$ Finding Start and End visible Row numbers

2015-03-08 Thread Ashish Kumar
Hi Eugene, Welcome..!! Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles

Re: $$Excel-Macros$$ Finding Start and End visible Row numbers

2015-03-08 Thread Eugene Bernard
Hi Asish, Thank you, The two line code is very useful for me. Thanks again. Eugene On Fri, Mar 6, 2015 at 5:04 PM, Ashish Kumar wrote: > Hi Eugene, > > > PFA, Filter your data then after hit the button > > > Regards > Ashish > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ Finding Start and End visible Row numbers

2015-03-07 Thread Vaibhav Joshi
Check this.. Cheers!! On Fri, Mar 6, 2015 at 5:04 PM, Ashish Kumar wrote: > Hi Eugene, > > > PFA, Filter your data then after hit the button > > > Regards > Ashish > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Faceboo

Re: $$Excel-Macros$$ Finding Start and End visible Row numbers

2015-03-06 Thread Ashish Kumar
Hi Eugene, PFA, Filter your data then after hit the button Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accura