SampleSheet.xlsHi,
I am having worksheet_change eveny specified in my sheet(sheet1 say cell A1). On this work sheet change event, I have a code that changes the cell value of some cell in another sheet(sheet2 say cell A2). I also have a formula using an userdefined function specified on some another sheet's cell (say Sheet3 cell A3). This function is something like isEmpty(Sheet1.A1).
Now the problem is, when the worksheet_change event of sheet1 is called. Just befor I write Sheet2.A2 = "", the call to isEmty function is made. This causes my original worksheet_change event to breaked withou running further. This is causing problem in my code to executed further.
Please help.
Also please note that issue is faced by me only in some machines. For the rest the macro works fine.
Bookmarks