Bet Angel - Example spreadsheets : Clearing the status cells in Excel

Example spreadsheets and comments on example spreadsheets.
Panrich
Posts: 3
Joined: Wed Feb 14, 2018 3:54 pm

Sun Feb 18, 2018 2:29 pm

I have just seen that this seems to be an issue with latest Excel versions. I can get around it for the moment by creating all my rules and formlae prior to connecting.

Tommolfc1990
Posts: 4
Joined: Mon Jun 03, 2019 7:42 pm

Fri Aug 30, 2019 11:42 am

nigelk wrote:
Tue Jan 13, 2015 12:04 am
http://www.tradersandpunters.com/knowledge-base/

3rd article
Hi Nigel, i am in the same situation but the link you posted doesnt work any more it seems. I have managed to spread mine over 60 sheets and it clears the cells when offline, but it wont place more than one bet because for some reason it clears the full sheet of formulas when connected to BetAngel.

I have created a seperate module for each sheet:

Sub Reset_Bet15()

Application.ScreenUpdating = False

Sheets("Bet Angel (15)").Select

Range("O6,O9,O11,O13,O15,O17,O19,O21,O23,O25,O27,O29,O31,O33,O35,O37,O39,O41,O43,O45,O47,O49,O51,O53,O55,O57,O59,O61,O63,O65,O67").Activate

Selection.ClearContents

Range("A1").Select

Application.ScreenUpdating = True

End Sub




Have any ideas?
Much appreciated

kqv91y
Posts: 30
Joined: Wed Aug 30, 2017 9:48 am

Fri Oct 25, 2019 10:12 am

Just add this to a module then call it from your sheet ie Call ClearMerged("Bet Angel (3)")

If you don't want to clear the Bet Angel generated cells then remove the Rg1.MergeArea.ClearContents line.

Sub ClearMerged(shtName As String)

Dim Rg As Range, Rg1 As Range
Set Rg = Sheets(shtName).Range("L9:O68")
If Rg Is Nothing Then Exit Sub
For Each Rg1 In Rg
If Rg1.MergeCells Then
Rg1.MergeArea.ClearContents
Else
Rg = ""
End If
Next
End Sub

User avatar
GaryCook
Posts: 119
Joined: Sat Jan 27, 2018 6:35 pm

Sat Jan 11, 2020 6:28 pm

Not sure what I am missing but it doesnt seem to work for me. It always says, "RESET REQUUIRED.". Even though the range is all clear.

firlandsfarm
Posts: 866
Joined: Sat May 03, 2014 8:20 am

Sun May 17, 2020 5:04 pm

nigelk wrote:
Tue Jan 13, 2015 12:04 am
http://www.tradersandpunters.com/knowledge-base/

3rd article
WARNING: I followed this link and was redirected from the expected address to one of suspicious makeup! It downloaded ransomeware. It was relatively easy to get out of (I used Task Master and closed all windows of the browser) but it was a pain recovering all the webpages I had open. I'm not an expert but I think Nigel's link is totally innocent because it first takes you to the intended address and then redirects. I suspect the target address has been doctored.

Post Reply

Return to “Bet Angel - Example spreadsheets”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest