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

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

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

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 apply

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

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

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" &

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

Hi Everyone, I have data in rows("A:A") like . Now I want to delete blank row and *C, D, E, F till last range in" A". how can I make macros for this * Name B C A B C A A A A B C C C C C B B C C C D E E F F F -- ---