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
Bookmarks