Inserting a variable number of rows in a worksheet

[kls]

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Tom Ogilvy]

numrows = 5
range("B9").EntireRow.Resize(NumRows).Insert