macro: insert specified number of rows depending on referenced cell value

[cffurillo]

Hello,

I would like to create a macro that adds a specified number of rows after row 10 in a sheet. The specified number of rows is based on a value in cell F6.

For example:

F6 = 112; I would like to add 112 blank rows after row 10.

Any thoughts? Thanks in advance.

[HaHoBe]

Hi, cffurillo,

something like

Please Login or Register  to view this content.

Ciao,
Holger

[cffurillo]

perfect ... thank you so much!