Copy,Paste and append row of data

[rdstagg]

This was a subject raised in 2002 - but no answer seems to have been found.

I use a DDE spreadsheet which adjusts share prices in real time.

I have managed to write a function in vb that beeps and turns cell w10 to true when a condition is met. (Sheet 1). Default is obviously false.

I would like to copy a row of data (row 11) when this happens and write it to sheet 2.

Each time the condition is met another row of data would be added to the same sheet .

This seems straightforward but I cannot work out how to do it

 

[Anthony47]

Maybe you missed this part of the instructions:

Modify ..... . . . . the dde link in the two SetLinkOnData instructions: you should put here the same link you have set in cell N11

Which is the formula in N11? That value should replace the current parametre in the SetLinkOnData instructions; you should have (in N11) something that has the same structure of what I used.

Let me know..

Bye,

 

[Anthony47]

REPOST, I am not sure this message went on-line:
Maybe you missed this part of the instructions:

Modify ..... . . . . the dde link in the two SetLinkOnData instructions: you should put here the same link you have set in cell N11

Which is the formula in N11? That value should replace the current parametre in the SetLinkOnData instructions; you should have (in N11) something that has the same structure of what I used.

Let me know..

Bye,

 

[Anthony47]

Hi rdstagg,
what did we make wrong?

Bye,