Re: $$Excel-Macros$$ Fwd: Village

2010-11-06 Thread roberto mensa
> > Thanks for the link. But is there a way to get an english translation of > the site? The link takes me directly to the page and to a language I do not > understand :) > > I use Mozilla Firefox (If this is any help) :) > > Thanks > > > Ashish > hello Ashish, you can use traslate google: http://

Re: $$Excel-Macros$$ Fwd: Delete rows from a Sheet based on value found on previous cell

2010-11-06 Thread Cesar Delanoval
Thank you very much, this worked great !!! Thank you, Thank you, Thank you!! On Sat, Nov 6, 2010 at 11:36 AM, Swapnil Palande wrote: > Hi, > > Pls find attached file for solution. > > Following is macro I have developed: > > Sub Delete_Rows() > Dim rng As Range, counter As Integer > Set rng = S

Re: $$Excel-Macros$$ Fwd: Delete rows from a Sheet based on value found on previous cell

2010-11-06 Thread CAN
I uploaded file "sample_sheet.xls" for review. When I tried the script it didn't work and I get an error On Nov 6, 6:59 am, "Daniel" wrote: > Hello, > Not fully tested : > Sub DeleteRows() > Dim i As Long, Res As Long > For i = Cells(Cells.Rows.Count, 1).End(xlUp).Row To 2 Step -1 >     If IsNum

RE: $$Excel-Macros$$ How can i enable all macros when start excel?

2010-11-06 Thread عمــــــــــــر
Thanks! But I want to do that automatically by code From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of P.VIJAYKUMAR Sent: Saturday, November 06, 2010 6:23 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How can i enable all macros when

Re: $$Excel-Macros$$ Fwd: Village

2010-11-06 Thread Ashish Pradhan
Hello Roberto Thanks for the link. But is there a way to get an english translation of the site? The link takes me directly to the page and to a language I do not understand :) I use Mozilla Firefox (If this is any help) :) Thanks Ashish On 11/5/2010 3:39 PM, roberto mensa wrote: little

RE: $$Excel-Macros$$ Fwd: Delete rows from a Sheet based on value found on previous cell

2010-11-06 Thread Daniel
Hello, Not fully tested : Sub DeleteRows() Dim i As Long, Res As Long For i = Cells(Cells.Rows.Count, 1).End(xlUp).Row To 2 Step -1 If IsNumeric(Split(Cells(i, 1), " ")(0)) And Mid(Cells(i, 1).Value, 2, 1) = " " Then Res = Split(Cells(i, 1), " ")(0) * 1 Exit For End If Next

Re: $$Excel-Macros$$ Best Wishes HAPPY DIWALI

2010-11-06 Thread ashish koul
Happy Diwali to you too. On Sat, Nov 6, 2010 at 1:40 PM, Ayush wrote: > Dear Members, > > My warm wishes to everyone on the joyous occasion of Deepawali. > > The festival of lights, Deepawali is an important occasion for > promoting brotherhood and fellow feeling among all sections o

$$Excel-Macros$$ Best Wishes HAPPY DIWALI

2010-11-06 Thread Ayush
Dear Members, My warm wishes to everyone on the joyous occasion of Deepawali. The festival of lights, Deepawali is an important occasion for promoting brotherhood and fellow feeling among all sections of the people. The festival celebrates the victory of good over evil and reflects the true spir