Ok Gary,
We must be looking at two different sheets.
The green up example assumes you don't have any additional columns displayed because it use columns Y to AB. If you are using column Y for the offset bet matched flag then you will need to adjust the output. You can change the following three lines in the calcGreenUp() sub in sheet1.
Code:
Cells(r, 25).Value = betType
Cells(r, 26).Value = stake
Cells(r, 27).Value = odds
Change them to read as follows to change the output columns from "Y to AA" to "Z to AB" for example.
Code:
Cells(r, 26).Value = betType
Cells(r, 27).Value = stake
Cells(r, 28).Value = odds
The above does not exist in sheet1.
What you have as part of a code in a module is
- Code: Select all
trigRange(r, 25).Value = betType
trigRange(r, 26).Value = stake
trigRange(r, 27).Value = odds
trigRange(r, 28).Value = backStake
trigRange(r, 29).Value = layStake
Next
End Sub
Which I already changed to the following to suit my sheet.
- Code: Select all
trigRange(r, 28).Value = betType
trigRange(r, 29).Value = stake
trigRange(r, 30).Value = odds
trigRange(r, 31).Value = backStake
trigRange(r, 32).Value = layStake
Next
End Sub
You will also need to move the "greened up P&L" column. Change the initMarket() sub to read as follows to change the output from column AB to AC.
Code:
Private Sub initMarket()
Dim r As Integer
Set selecIndex = New Collection
r = 5
Do
r = r + 1
Loop Until Cells(r, 1) = ""
Set plRange = Range(Cells(5, 24), Cells(r - 1, 24))
Set levelPLRange = Range(Cells(5, 29), Cells(100, 29))
levelPLRange = ""
Set levelPLRange = Range(Cells(5, 29), Cells(r - 1, 29))
End Sub
Can't find this above sub
initMarket() any where.
The way my sheet is at present:
Y column displays offset bet matched
Z col = Offset bet references
AA col = Average last price matched
AB col = Green up Bet (displays either BACK or LAY)
AC col = stake
AD col = Odds
AE col = Matched Backs
AF col = Matched Lays
It's no big deal if the Green up P/L column is not there. I have done a column for it myself. I only raised the question because you mentioned it's there.
Cheers
Dan
