Rows

Home Search Site Map

Up
Cells...
Chart...
Columns
Comment
Diagram...
Function...
Hyperlink...
Name
Object...
Page Break
Picture
Rows
Symbol...
Worksheet

New! Excel User Group Now Open @ www.excelusergroup.org, Check It Out!


Menu command Type What happens next?
Rows  

Inserts a row(s) from the current selected cell(s) or row(s). Rows can only be moved down , so careful pre-selection is very important.

Sub InsertRows()
'Insert three rows at row 11
Range("A11:A13").EntireRow.Insert
End Subub

Copyright Nick Hodge 2008. All Rights Reserved.