Help on worksheet_change
I have the following code
I have a formula in the cell "F5" which is used in the "intersect" method. when the value of the cell "F5" is changed based on the formula which depends on many other cells in the worksheet the following code should be executed. But it doesn't happen.Please help me with this "intersect" method.
Please Login or Register to view this content.
Please attach the file you are using.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Sorry for the Inconvenience but i cannot upload my files,its kind of confidential
You do not need to upload your original file. Just a dummy file will do as long as the format, headers, formulae etc match your original file.
Please Login or Register to view this content.
Last edited by arlu1201; 05-14-2012 at 09:10 AM. Reason: Code tags not php tags.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks