insert rows and copy formats into those rows

[stevekirk]

hi,

i would like to be able to insert a number of rows selected by an input box
that numbers of rows would then be inserted after row 34. the formats, formulars etc from row 34 to be placed into the inserted rows.

thanks
steve

[VBA Noob]

See if this link helps

http://www.mvps.org/dmcritchie/excel...w.htm#insrtrow

VBA Noob

[stevekirk]

thanks working now ok

steve

[VBA Noob]

Glad it helped

VBA Noob