Good Morning, Tsjallie
Sorry, the misunderstanding was mine. I didn't get iso.
Here is the code I have now.
I may have two problems.
Please Login or Register to view this content.
1. Of course, the code does not run.
2. There are many cells in this worksheet that change. How can I make sure only cell E9 runs the code?
Thanks for your generous time and assistance.
KarlaM
This code is odd--why would you assign five different values to the same cell? Only that last one matters.
What module is this code in? Is it the same sheet that you want to detect changes in? If it is not, that's your problem. If it is, then put in a breakpoint or a MsgBox call to see if it is entering the code. Better yet, attach your file here.
Please Login or Register to view this content.
nevermind. already answered.
Hi Jeff,
I added the two lines as you suggested and changed cell E9. Nothing happened. I inadvertently changed the data in a different cell, and the code tried to run. The error message was "Compile Error: Sub or Function not defined" and VBA highlighted: Worksheet("PPW").Range("E9") = A
I created the sub from the PPW worksheet object.
My attempt to upload the workbook failed. It is 2200KB, maybe too big? What is the size limit for uploads? I can try to build a smaller file over the weekend.
Thanks!
Karla
I didn't catch this the first time around. The correct code is:
You might try zipping the file and see if that's under the limit. Limits can be found in the "?" link when you click on the paper clip to attach a file:Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks