Help with VB to run a macro

[Mitch]

I've always struggled getting the Calculate event to work so due to lazyness I use the Change event.

I think Calculate will fire when a cell changes due to the result of a formula changing, which should be the case with the cell AA1 as suggested earlier. I'll have a play around with it if I get the chance but it looks like between you you will have it sussed before long anyway.

[allgreen]

dermag, it was remiss of me not to mention this before but the reason I was wanting to use SUM(X5:X28) is that I am betting into the place market with this sheet so any matched bets only change the P/L for the individual horse, not every horse in the field.

I was sitting here wondering how getting the change from only the last cell was going to do the trick when it finally dawned on me the difference in display of P/L for the two markets. Doh... Nonetheless all ideas generated from this discussion will no doubt come in handy somewhere down the track.

[dermag]

Hi allgreen,

I see what you mean about the place market. I'll keep at it and I'm sure between the forum we can come up with something.

A question though, if you don't mind. Why do you prefer worsheet_calculate over worksheet_change ? You can have your problem solved by using the _change event rather than the _calculate event. Same end result, just a different way there.

[allgreen]

dermag, if I can get my desired result I don't really care which means I have to use to do it. I don't have a preference for one or the other it's just that my limited VBA knowledge was leading me in a particular direction. I think initially I had arrived at the conclusion that worksheet_selection.change was the way to go then when I found this wasn't the case I thought worksheet.change probably also wouldn't work - thinking selection.change was just a refinement of worksheet.change, which it apparently isn't.

I have bought myself a copy of VBA for dummies so hopefully can read this over Easter and gain some rudimentry knowledge of the subject.

If you can accomplish what I want to do using worksheet_change then that is fine by me.

[dermag]

edited due to what seems to be a replicated post by me

[allgreen]

dermag, I rearranged my worksheets so I could use your code and tried it for the first time over the weekend and it worked perfectly. Thanks very much for your help.

[dermag]

Hi allgreen,

No problems. Glad you got it working.