Hmm, I can't think of a reason that it would fail. After you get the error, what does it say CellAddress is equal to when you hold the cursor over it while debugging?
Otherwise if you could post the workbook, that'd make it easier to troubleshoot.
Hmm, I can't think of a reason that it would fail. After you get the error, what does it say CellAddress is equal to when you hold the cursor over it while debugging?
Otherwise if you could post the workbook, that'd make it easier to troubleshoot.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Ok here is a chopped down version of the workbook.
I have changed the sheet event to 'calculate' and the first part now seems to work when payments are set up but when it comes to the the sheet 9 update, the code it gets stuck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks