HLC
Dear Krishna Mummina,
I saw yr solution to the question of Niel Johnson. As i am a primary
student in Excel I don't know how to create Excel Macro. I would like to
know how to apply these commands in excel and how to use it. Shall I except
yr kind help. Kindly enlighten me using or applying the following commands
step by step in excel.
delete the entire row when specification meets
Sub processdata()
Dim i As Long, lr As Long
lr = ActiveSheet.UsedRange.Rows.Count
> Application.ScreenUpdating = False
For i = 1 To lr
> If Range("A" & i).Value = "" Then Range("A" & i).EntireRow.Delete
If UCase(Range("A" & i).Value) = "C" Then Range("A" & i).EntireRow.Delete
If UCase(Range("A" & i).Value) = "D" Then Range("A" & i).EntireRow.Delete
If UCase(Range("A" & i).Value) = "E" Then Range("A" & i).EntireRow.Delete
If UCase(Range("A" & i).Value) = "F" Then Range("A" & i).EntireRow.Delete
> Next
Application.ScreenUpdating = True
End Sub
Hari Lal
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
