VBA help - record last odds requested

[ladders]

hi there,

I am using Excel triggered betting and would like to be able to record the last odds at which i tried to lay a selection.

My understanding is that a macro which would copy the odds i have requested to lay when the instruction cell says 'LAY' would do the job.

I'm sure i have managed this successfully in the past but this was a long time ago and it doesn't seem to work now.

I am good with excel formulas but useless with VBA, can anyone let me know how i can do the above?

thanks,
Paul

[ladders]

Can anyone tell me why this VBA doesn't work? - i'm sure i have managed to trigger macros before with the top code but it doesn't seem to work now.

In the code window for the sheet to which the data is going, i have the following:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Columns.Count <> 16 Then Exit Sub
Application.EnableEvents = False

Run "CopyRtoZ"

Application.EnableEvents = True

End Sub

In Module1 i have:

Sub CopyRtoZ()
'
' CopyRtoZ Macro
'
Range("R5:R6").Select
Selection.Copy
Range("Z5").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub

I don't understand why the above does not trigger a copy of the odds i am requesting (in R5 and R6) to Z5 and Z6.

I can't seem to get any macro to trigger with the top bit of code - has the number of target columns changed?

thanks,
Paul

[ladders]

i believe i've solved the problem - it was my anti virus software stopping the triggering of worksheet change macros in Excel 2007.

[ladders]

well, it worked once then stopped again. i cant get any worksheet change macros to work now - anyone know how i can disable all security settings so i can eliminate these from being the issue?

[Ian]

Tools -> Macro - > Security and set the level to low ?

Not sure this will work for you, but I had a similar problem when I installed Excel on a new machine. Kept wanting to virus check any workbook with a macro.