The following does not seem to work with the Sample File. All I want is a blank line to follow after Category appears in the line above. Ron
On Wed, Apr 4, 2012 at 3:16 PM, dguillett1 <dguille...@gmail.com> wrote:
> Option Explicit
>
> Sub InsertRowsSAS()
> Dim lr As Long
> Dim r As Range
> Application.ScreenUpdating = False
> lr = Cells(Rows.Count, 1).End(xlUp).Row
> With Range("a2").Resize(lr)
> .AutoFilter Field:=1, Criteria1:="=category*"
> For Each r In .SpecialCells(xlVisible)
> Rows(r.Row + 1).Insert
> Next r
> .AutoFilter
> End With
> Application.ScreenUpdating = True
> End Sub
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Ronald Cayne <ronca...@gmail.com>
> *Sent:* Wednesday, April 04, 2012 1:47 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Inserting blank row
>
> Sample File Attached
>
> Many Thanks
> Ron
>
>
>
>
> On Wed, Apr 4, 2012 at 10:50 AM, vijayajith VA <vijayajith...@gmail.com>wrote:
>
>> Hi Cayne,
>>
>> Sub rowinsertcola()
>>
>>
>> Dim i, j, k, z, h As Long
>> j = 1
>> z = 1
>>
>>
>> Range("a65356").Select
>> Selection.End(xlUp).Select
>>
>> k = ActiveCell.Row
>>
>>
>>
>>
>> For i = 5 To k + z Step 1
>>
>>
>>
>> If (i Mod j = 0) Then
>>
>> ActiveSheet.Cells(i + z, 1).Select
>>
>> Selection.EntireRow.Insert
>>
>>
>> z = z + 1
>>
>>
>> End If
>>
>> Next i
>>
>> End Sub
>>
>>
>>
>> Thanks to ayush
>>
>> On Wed, Apr 4, 2012 at 4:37 PM, Ronald Cayne <ronca...@gmail.com> wrote:
>>
>>> Have a list in excel within one column
>>>
>>> Name
>>> Tel
>>> Address
>>> Has data or not
>>> Has data or not
>>> Category: eg "Category: Designers" This line always has the word
>>> "Category" on extreme left
>>> Want to insert blank line after this line.
>>> Macro to perform task. SVPACCIDENT
>>>
>>> Thanks
>>> Ron
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> ------------------------------------------------------------------------------------------------------
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> ------------------------------------------------------------------------------------------------------
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ------------------------------------------------------------------------------------------------------
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ------------------------------------------------------------------------------------------------------
> To post to this group, send email to excel-macros@googlegroups.com
>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
Sample File.xls
Description: MS-Excel spreadsheet
