gt; Application.ScreenUpdating = True
> End Sub
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Ronald Cayne
> *Sent:* Wednesday, April 04, 2012 1:47 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Mac
t
Next r
.AutoFilter
End With
Application.ScreenUpdating = True
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ronald Cayne
Sent: Wednesday, April 04, 2012 1:47 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Inserting blank row
Sample
Sample File Attached
Many Thanks
Ron
On Wed, Apr 4, 2012 at 10:50 AM, vijayajith VA 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
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
macros@googlegroups.com
Subject: $$Excel-Macros$$ Inserting blank row
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
rngRange.Value = "Category: "
rngRange.Offset(1).EntireRow.Insert
End Sub
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ronald Cayne
Sent: Apr/Wed/2012 05:00
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Inserting blank row
Ie Every time the word Category appears insert a line.
On Wednesday, April 4, 2012, Ronald Cayne 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
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+ memb
