Copy the row above where you want the new row.
Select the row immediately below.
Right-click the row header and choose "Insert Copied Cells" from the popup menu.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
"JDNETTC"
wrote in message
When I insert a row, it will give me a blank row. I am trying to insert a
row in the middle of many rows of formulas, and I want the row to be
auto-populated with the correct formula.
Instead of:
Row 1 =kdkdkdk =kdkdkdkd =kdkdkdk
Row 2 (inserted and blank)
Row 3 =kdkdkdkd =kdkdkdkdk =dkdkdk
I want:
Row 1 =kdkdkdk =kdkdkdkd =kdkdkdk
Row 2 (inserted) =kdkdkdkd =kdkdkdkdk =dkdkdk
Row 3 =kdkdkdkd =kdkdkdkdk =dkdkdk
My actual spreadsheet is more complicated, but the principle is what I need
to get working.
JD