View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Otto Moehrbach
 
Posts: n/a
Default Tables, How do I make new info push existing info to the next row?

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
"PeteL" wrote in message
...