how do I double or triple an existing EXEL file
 

how do I double or triple an existing EXEL file

how do I double or triple an existing EXEL file
 

hi
what do you mean by double or triple an existing excel file???

regards
FSt1

"floatinghawk" wrote:

how do I double or triple an existing EXEL file

how do I double or triple an existing EXEL file
 

If I have 100 entries, one under the other,...I want it every 3rd line so
I can write notes under each one.

"FSt1" wrote:

hi
what do you mean by double or triple an existing excel file???

regards
FSt1

"floatinghawk" wrote:

how do I double or triple an existing EXEL file

how do I double or triple an existing EXEL file
 

Are you looking for insert rows between data?
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"floatinghawk" escreveu:

If I have 100 entries, one under the other,...I want it every 3rd line so
I can write notes under each one.

"FSt1" wrote:

hi
what do you mean by double or triple an existing excel file???

regards
FSt1

"floatinghawk" wrote:

how do I double or triple an existing EXEL file

how do I double or triple an existing EXEL file
 

I am looking for 2-3 blank rows between vertical rows for hand written notes.

"Marcelo" wrote:

Are you looking for insert rows between data?
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"floatinghawk" escreveu:

If I have 100 entries, one under the other,...I want it every 3rd line so
I can write notes under each one.

"FSt1" wrote:

hi
what do you mean by double or triple an existing excel file???

regards
FSt1

"floatinghawk" wrote:

how do I double or triple an existing EXEL file

how do I double or triple an existing EXEL file
 

Sub InsertRows()
Application.ScreenUpdating = False
Dim NumRows As Integer
Dim Lrow As Long
Dim r As Long
Lrow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row
NumRows = 2
For r = Lrow To 1 Step -1
ActiveSheet.Rows(r + 1).Resize(NumRows).EntireRow.Insert
Next r
Application.ScreenUpdating = True
End Sub


Gord Dibben MS Excel MVP

On Tue, 12 May 2009 15:17:02 -0700, floatinghawk
wrote:

If I have 100 entries, one under the other,...I want it every 3rd line so
I can write notes under each one.

"FSt1" wrote:

hi
what do you mean by double or triple an existing excel file???

regards
FSt1

"floatinghawk" wrote:

how do I double or triple an existing EXEL file

how do I double or triple an existing EXEL file
 

If it's for hand written notes, maybe you could just select the range and then
increase the rowheight by a factor of three.



floatinghawk wrote:

I am looking for 2-3 blank rows between vertical rows for hand written notes.

"Marcelo" wrote:

Are you looking for insert rows between data?
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"floatinghawk" escreveu:

If I have 100 entries, one under the other,...I want it every 3rd line so
I can write notes under each one.

"FSt1" wrote:

hi
what do you mean by double or triple an existing excel file???

regards
FSt1

"floatinghawk" wrote:

how do I double or triple an existing EXEL file

--

Dave Peterson