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
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