by fogosan » Fri Aug 10, 2007 7:33 pm
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