Inserting row/column (Excel Windows 2000)

Topic

New Reply

Could some remind me what the command is to insert a row or a column into a spreadsheet. Thanks.

Farmer

Reply | Quote

Replies

To insert a new row 10 (and push existing data down):

Rows(“10:10”).Insert

To insert a new column F (and push existing data to the right):

Columns(“F:F”).Insert

Reply | Quote

Thanks for that. Suppose. I just want to insert one extra row when sitting in an empty cell, say I’m in cell A56 and want to insert an extra row there. Thanks.

F

Reply | Quote

If you want to insert a row at the currently active cell, use

ActiveCell.EntireRow.Insert

Simiularly, use EntireColumn if you want to insert a column.

Reply | Quote

Much appreciated.

f

Reply | Quote