RE: $$Excel-Macros$$ Insert row based on criteria

2011-02-28 Thread Pehrson, Dave
pport. Dave From: ashish koul [mailto:koul.ash...@gmail.com] Sent: Saturday, February 26, 2011 10:45 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Insert row based on criteria hi dave Sub newrow() Dim i As Long For i = Sheets(1).Range("a1").End(xlDown).Row T

Re: $$Excel-Macros$$ Insert row based on criteria

2011-02-26 Thread Diamond Dave
I'm also trying it insert a row, but in my example, I want to insert in after the "SubTotal" after using the "subtotal function" adding the blank row after the subtotal line. How would you modify the macro in your example to accomplish this? Dave On Feb 26, 12:44 am, Mahesh parab wrote: > Hi Ja

$$Excel-Macros$$ Insert row based on criteria

2011-02-25 Thread Jason Henke
Hello, In the attached file I have provided an example of what I am trying to accomplish via macros. I import a report into excel that changes each time it's ran. I'm trying to put a space after each 'group' is ran. As an example we have locations set up as A-A-0 A-A-1 ect..to A-C-3 B-A-0 to B-F