Dear Ashish, Thank U so much. The marco is working fine in module. But, It don't update automatically. Everytime we will edit it and press enter. But if we have lots of data then it is not possible to edit & press enter everytime. For that we has checked Tools Menu - Options - Calculations - Automatic. But thereafter it is not updated. Please help me.
Regards, Lavprasad Kori On Sat, Feb 21, 2009 at 2:27 PM, Lavprasad Kori <lavprasa...@gmail.com>wrote: > Dear Ashish, > > Thanks for the reply. When I go to below mentioned site. There is macro > program. I had gone by step by step. but I am not getting the answer. There > is an #Name error has occured. Please help me & attached the same file. > > > Thanks & Regards, > > Lavprasad Kori > MIS Executive - Water > Hindustan Unilever Limited > Tel. 022 - 39833428 > > On Sat, Feb 21, 2009 at 1:43 PM, Ashish Jain <26may.1...@gmail.com>wrote: > >> ---------------------------------------------------------------------- >> Hi LavPrasad, >> >> Here is the solution to your query: >> http://www.excelitems.com/2009/02/count-5-consecutive-zeroes.html >> >> Regards >> Ashish Jain >> Analyst and Demand-Co-ordinator, CSC Australia >> Microsoft Office Specialist >> Technical Trainer - Excel and VBA >> 09999-40-48-43 >> >> ---------------------------------------------------------------------- >> >> >> >> >> On Sat, Feb 21, 2009 at 11:12 AM, Lavprasad Kori >> <lavprasa...@gmail.com>wrote: >> >>> >>> Dear All, >>> >>> I want an urgent help for the below metioned data. >>> >>> Attaching hererwith the data file. >>> >>> I want a help to count the zero value if it comes continues 5 times or >>> more than 5 times then count as 1 time & If it comes continue less than 5 >>> times then ignore it. >>> >>> -- >>> Thanks & Regards, >>> >>> Lavprasad Kori >>> MIS Executive - Water >>> Hindustan Unilever Limited >>> Tel. 022 - 39833428 >>> >>> >>> >> >> >> -- >> Regards >> Ashish Jain >> >> >> >> >> >> >> > > > -- > -- Thanks & Regards, Lavprasad Kori MIS Executive - Water Tel. 022 - 39833428 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
