David,
Try something like
Range("A10").EntireRow.Insert
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"david" wrote in message
...
how to programmingly insert a new row in excel sheet?
(using VB code)