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

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

The solution Don gave you has a downside. That solution inserts rows all the
time instead of just moving down the column to the next empty cell. Aren't
you just wanting to find the empty cell and make that cell "active" before
the program pastes the new data there?
Richard Choate

"Don Guillett" wrote in message
...

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