| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I double or triple an existing EXEL file
how do I double or triple an existing EXEL file
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Double (triple?) Index Lookup | Excel Worksheet Functions | |||
| Excel 2007 opens two workbooks when I double click existing file | Setting up and Configuration of Excel | |||
| Can't open existing files by double-clicking. | Excel Discussion (Misc queries) | |||
| Importing text file, only option to edit existing file | Excel Discussion (Misc queries) | |||
| I need to download an exel spreadsheet file. (file extension :xls) | Excel Discussion (Misc queries) | |||
Linear Mode
