close
Provide more detail about what you are wanting to do. For instance, where
is the new info coming from? User entry? By VBA code?
You would need VBA to insert a new row or rows above the existing data.
For instance, the following inserts a new blank row above the current row 2.
HTH Otto
Sub Test()
Rows(2).EntireRow.Insert
End Sub
quot;PeteLquot; gt; wrote in message
...
gt;
全站熱搜