Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yet another macro question
This is what I get for trying this on my own. I just want a macro that will
insert 2 blank rows at the current cursor position. Sub Insert2Rows() ' ' qrow = ActiveCell.Row Rows(qrow & ":" & grow + 1).Selection.Insert Shift:=xlDown End Sub Any ideas? Thanks! Amy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yet another macro question
This should be close...
Sub Insert2Rows() ActiveCell.Resize(2, 1).EntireRow.Insert End Sub -- HTH... Jim Thomlinson "cvgairport" wrote: This is what I get for trying this on my own. I just want a macro that will insert 2 blank rows at the current cursor position. Sub Insert2Rows() ' ' qrow = ActiveCell.Row Rows(qrow & ":" & grow + 1).Selection.Insert Shift:=xlDown End Sub Any ideas? Thanks! Amy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yet another macro question
Hi,
Maybe this Sub Insert2Rows() ' qrow = ActiveCell.Row Rows(qrow).Resize(2).Insert End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "cvgairport" wrote: This is what I get for trying this on my own. I just want a macro that will insert 2 blank rows at the current cursor position. Sub Insert2Rows() ' ' qrow = ActiveCell.Row Rows(qrow & ":" & grow + 1).Selection.Insert Shift:=xlDown End Sub Any ideas? Thanks! Amy |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yet another macro question
As usual, you guys rock!
"Jim Thomlinson" wrote: This should be close... Sub Insert2Rows() ActiveCell.Resize(2, 1).EntireRow.Insert End Sub -- HTH... Jim Thomlinson "cvgairport" wrote: This is what I get for trying this on my own. I just want a macro that will insert 2 blank rows at the current cursor position. Sub Insert2Rows() ' ' qrow = ActiveCell.Row Rows(qrow & ":" & grow + 1).Selection.Insert Shift:=xlDown End Sub Any ideas? Thanks! Amy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
Macro question | Excel Discussion (Misc queries) | |||
Macro question | Excel Worksheet Functions | |||
question on macro | Excel Discussion (Misc queries) | |||
Macro Question | New Users to Excel |