Beta version - How are data sent to Excel (VBA problem)

[fogosan]

Hi,

I apologize, if somebody already discussed this problem.
I am working on macro in Excel (using BA Beta 1.0.0.53.). Basically, I try to copy data from place to another place in the same worksheet after refreshment from BA.

VBA code is like this:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
CODE
Application.EnableEvents = True
End Sub

My problem is that, after BA refresh my data are copied 2 or 3 times. There is only one change from BA, but Excel makes copy operation more times.
Does somebody have experience with this situation? Is there somtheing wrong in my code?

Thanks

fogosan

[Ian]

There are a number of posts about this

eg . http://gruss-software.co.uk/forum/viewt ... ght=target

You need to specify which in cells you want to see a change before the macro runs.

[fogosan]

Ian,

This magic line of code fixed my problem (If Target.Columns.Count <> 16 Then Exit Sub ).
Next time I will read all topics more deeply.

Thanks,
fogosan