Macro Help Pls

[Steve Voltage]

I have recorded the following Macro which seems to work well but when the odds i have in AA5 and AA6 are pasted in R5 and R6 a bet is not placed. Can anyone enlighten me on what i am doing wrong please.

Cheers.

Code: Select all

Sub Macro1()
'
' Macro1 Macro
'

'
    Range("AA5").Select
    Selection.Copy
    Range("R5").Select
    ActiveSheet.Paste:
    Application.Wait (Now + TimeValue("00:00:05"))
    Range("AA6").Select
    Selection.Copy
    Range("R6").Select

End Sub
    ActiveSheet.Paste:

[Steve Voltage]

ahh why can you not edit threads!

Code: Select all


Sub Macro1()
'
' Macro1 Macro
'

'
    Range("AA5").Select
    Selection.Copy
    Range("R5").Select
    ActiveSheet.Paste:
    Application.Wait (Now + TimeValue("00:00:05"))
    Range("AA6").Select
    Selection.Copy
    Range("R6").Select
    ActiveSheet.Paste:

End Sub



[NorthView]

It can be done in one line:

Range("R5:R6").Value = Range("AA5:AA6").Value

Also you should be avoiding use of Select, as it's an unnecessary overhead.

[Steve Voltage]

That wouldn't work mate as I'm trying copy and paste the cells with a 5 second interval. Your way would copy and paste both cells at once.

[NorthView]

You should be able to adapt what I posted to suit your needs.

[Steve Voltage]

You should be able to adapt what I posted to suit your needs.

I can use what you suggested but it still does not place a bet when linked to BA. The Macro continues to run and places the odds in (R5) but not bet is placed. It is as the odds are not recognised when using a macro to populate them.

[Captain Sensible]

It is as the odds are not recognised when using a macro to populate them.

Are you getting error messages to confirm that like ERROR_READING_ODDS_OR_STAKE or just guessing? Plenty of us use macros to populate the odds/stakes/triggers with no problem. What errors are you getting, have you tried checking the values sent are numbers?

[Steve Voltage]

Not getting errors mate. The Macro poulatse R5 with the odds but nothing happens.

[Captain Sensible]

Hard to second guess where it's going wrong from the bits you've posted tbh. Gruss has plenty of error trapping to cover cells containing text or incorrect odds are you sure your trigger is valid and is everything entered at once, trigger,stake and odds, is the bet ref cell empty etc?

[Steve Voltage]

Ok cheers. All i can suggest is if you tries the code i have posted.

Anyway i've abandoned the Macro and am now using simple formulas without an issue. Thanks anyway.

[Captain Sensible]

Good to see you've managed to sort it. The code you posted didn't contain any triggers etc just the R column so wouldn't tell me much tbh.

[Steve Voltage]

The trigger and stake are already populated this macro is purely just to populate the odds column. Try it with any trigger or stake. Anyway thanks for showing an interest.