Re: $$Excel-Macros$$ Delete rows including blank row except few members

2010-11-08 Thread krishna mummina
Hi Hari, Just Insert the Code in VBA Module, Like, press Alt+F11, VBA window will open, then, just from the menu bar, Insert , Module, there you will place the code. Here is a link: www.contextures.com/xlvba01.html Keep Smiling, On Mon, Nov 8, 2010 at 9

Re: $$Excel-Macros$$ Delete rows including blank row except few members

2010-11-07 Thread Hari Lal. C
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 appl

Re: $$Excel-Macros$$ Delete rows including blank row except few members

2010-11-07 Thread krishna mummina
Try this: It will 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" &