$$Excel-Macros$$ Re: additional row creation

2014-03-14 Thread E J
Thanks, Ravinder! I really appreciate it! On Thursday, March 13, 2014 3:33:25 PM UTC-7, E J wrote: > > Hi Everyone, > > I was wondering if I could get help with a macro. I'm trying to write a > macro (with no luck) that walks down a column based on the initial > place

Re: $$Excel-Macros$$ additional row creation

2014-03-14 Thread E J
Thanks, Vikas. Wow. This is great! I sincerely appreciate it. On Thursday, March 13, 2014 10:18:44 PM UTC-7, Vikas Verma wrote: > > Hi E J try this... > > > Sub testing() > > Dim rng As Range > Dim rcount As Long > Dim cel As Range > > rcount = Sheets(1).Cel

$$Excel-Macros$$ additional row creation

2014-03-13 Thread E J
Hi Everyone, I was wondering if I could get help with a macro. I'm trying to write a macro (with no luck) that walks down a column based on the initial placement of the active cell. Every time there are two cells with different data it adds two (or N rows). It doesn't, however, view blank cel

$$Excel-Macros$$ row addition macro

2014-03-13 Thread E J
Hi Everyone, I was wondering if I could get help with a macro. I'm trying to write a macro where the macro walks down a column of data based on where I initially highlight the active cell. If the data in two consecutive cells are different it adds 2 rows (or N rows). I've attached an example o