Excel help - worksheet change event

[alrodopial]

Hi everyone,
I want at the same time to record odds - bet at more than two markets in the same workbook. So i have lets say at list two sheets with names BF1, BF2 etc and i log BF prices into them (different markets into different sheets -BF1-BF2...-).
In order for the bets to be fired (or for odds to been coppied) i'm using the Workbook_SheetChange event as advised.

Code: Select all

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

If Target.Columns.Count <> 16 Then Exit Sub
..... rest of code here

The problem is that since markets updade at different time periods the lets say "copy odds macro" for the second sheet - market is fired AND when there is an update in the first sheet-market.
Is there a way that the change event become specified?Like the below:

Code: Select all

If Target.Sheets("BF1").Columns.Count <> 16 Then Exit Sub

So it will be enabled only if there is an update at lets say first sheet-market?
Thanks
Alex

[Roger]

I'm using two sheets in the same workbook, each sheet is getting different races loaded. But I use an identical copy of the same program in each sheet, using

Code: Select all

Private Sub Worksheet_Change(ByVal Target As Range)

End Sub


This way, each sheet deals with its own race. Does that help?

[alrodopial]

Thanks mate, the

Code: Select all

Private Sub Worksheet_Change(ByVal Target As Range)


If Target.Columns.Count <> 16 Then Exit Sub

does the job.
Similar event but refers to specific sheet as it is placed inside the required sheet.