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
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 i
For
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
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 dcolarde...@free.fr 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
Thank you very much, this worked great !!!
Thank you, Thank you, Thank you!!
On Sat, Nov 6, 2010 at 11:36 AM, Swapnil Palande swapnilp1...@gmail.comwrote:
Hi,
Pls find attached file for solution.
Following is macro I have developed:
Sub Delete_Rows()
Dim rng As Range, counter As
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: