by GustavW » Wed Jul 28, 2010 2:46 pm
I have written a macro that is supposed to trade. I put the code under the Worksheet_calculate method. Will this run the code every time the excel spreadsheet opens? Or should I name the macro Auto_Open?
Also, on the first row of the code I check if the timer-cell is 00:00:00, and if it is, the program should move to the next race in the quickpick-list.
The code is:
If Sheet1.Cells(2, 4) = "00:00:00" Then
Sheet1.Cells(2, 17) = "-1"
End If
where the Sheet1.Cells(2, 4) is the timer-cell, and Sheet1.Cells(2, 17) is the special trigger-cell (I think).
Am I stupid to think this is going to work? Should I declare the content of the timer-cell as a string (I really don't need to handle them as numbers)?