Forum Discussion
Private Sub Routine is not functioning
Hi What would be the reason for, not working Private sub routine automatically whenever any changes done in range. Private Sub Worksheet_Change(ByVal Target As Range) whenever I restart the...
Its working first time after the excel restarts.
I don't see any issues with your code. By chance, do you have other event procedures, such as "selection_change"?
Another thing you could try, is setting a break point in your code (click in the gray area to the left and you see a circle with the line highlighted - click again to remove it). When your code runs, it will stop on this line. Then, you can hit the F8 key to step through it and follow the flow of your program. Perhaps it will help identify where the issue is.
- See I tried. still its not working, but its working all "open" excel sheet closes and restart the excel.
So my doubt is on other excel sheets opened and which had already codes.