adding rows from cell value?

Ahjem · Apr 24th, 2002, 07:28 AM

i need to know how to add some rows in a table automatically, with a macro.

the number of rows added depends on what number is input into a certain cell

Ahjem · Apr 24th, 2002, 07:48 AM

?

Dinictus · Apr 24th, 2002, 08:13 AM

Make the cell tell you how big a range to select before inserting rows.

Base cell content:
Cells(1, 3)

make a sub that sort of says:

Rows("11:&Cells(1, 3)").Select
Selection.insert Shift:=xlDown

Otherwise you could try using the cstr function to draw a value from a cell.

gluck

Ahjem · Apr 24th, 2002, 08:15 AM

thank you

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 07:28 AM	#1
Ahjem New Member Join Date: Apr 2002 Posts: 12	i need to know how to add some rows in a table automatically, with a macro. the number of rows added depends on what number is input into a certain cell

Apr 24th, 2002, 07:48 AM	#2
Ahjem New Member Join Date: Apr 2002 Posts: 12	?

Apr 24th, 2002, 08:13 AM	#3
Dinictus Board Regular Join Date: Mar 2002 Posts: 162	Make the cell tell you how big a range to select before inserting rows. Base cell content: Cells(1, 3) make a sub that sort of says: Rows("11:&Cells(1, 3)").Select Selection.insert Shift:=xlDown Otherwise you could try using the cstr function to draw a value from a cell. gluck

Apr 24th, 2002, 08:15 AM	#4
Ahjem New Member Join Date: Apr 2002 Posts: 12	thank you