try this. It will insert a row after the active row if in col A
right click sheet tabview codeinsert thissave

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column < 1 Then Exit Sub
Rows(Target.Row).Insert
End Sub

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Trader" wrote in message
m...
I have a live stock market feed running into excel via DDE and it
updates intraday prices and volumes in the nominated row as trades
take place



Market Price Volume Time


FTSE100 3325 16 11.52



What I need to do is as the value changes in the row which is when a
trade takes place it records it in the next empty row eventually
creating a database.

If anyone can find the time for an answer it would be greatly
appreciated