Rows

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

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.
Rows		Sub InsertRows() 'Insert three rows at row 11 Range("A11:A13").EntireRow.Insert End Subub