Fix How Horses are Ranked in BetAngel Spreadsheet

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
TheNagsHead
Posts: 44
Joined: Fri Sep 07, 2018 4:30 pm

The post below is copied from the forum. I understand the Match & VLookup Function but dont understand how to add the VBA Code to make it work. Any help appreciated.



If you've copied a list of the runners into another sheet, you can always use the 'Match' function to get the row number, and the Vlookup to get the price.
No matter where Poets Society appears on the Bet Angel sheet, it will always point to the correct row, so even if it moves to the end of the list, the correct row number will be returned.

If you want to back Poets Society, for example, in vba i would write something like:

RowNum=sheets("Sheet2").Range("B2")
Sheets("Bet Angel").cells(RowNum,12)="Back"
You do not have the required permissions to view the files attached to this post.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”