In sheet3 there are some prices in A5:A15 and a simple graph for these prices. I'm trying to create a graph displaying the back prices for the fav before the race and maybe in running - like the betfair graph-.
A macro inserts a row in sheet1:
- Code: Select all
Sheets("Sheet1").Rows("9:9").Insert Row
These is neccesery for recording purpuses.
If i have opened-activated the sheet3 - the one with the graph - i want to watch the price movements in the graph- and run the macro for inserting the row i get an error
" Run-time error '13' Type mismatch "
But if i have opened-activated ANY other sheet the macro is executed with no errors.
I want to watch the graph changes so any help would be wellcome. Watching the graph creates the problem
For test there is no need prices A5:A15 to change, problem still exists and with static prices.
Alex