Thanks for all the help you guys have given me!
So I'm still working on the same sheet, just working out the kinks... for some reason I'm running out of stack space? Here is where the debugger is taking me. I have zero clue what's wrong, any advice?
13241234.png
Try turning off events at the start of the code with this,
but don't forget to turn them back on at the end.
Please Login or Register to view this content.
Please Login or Register to view this content.
If posting code please use code tags, see here.
This hasn't solved it, for some reason I'm still getting that error, any idea why? Could it be caused by some other part of my code? Why would it send me there?
Any chance you could upload a sample workbook?
Click on GO ADVANCED and use the paperclip icon to open the upload window.
I would like to, but there is way to much sensitive information in the file. Is there simply a different way that I could do what I'm trying to do and see if that fixes it? Maybe and IF statement?
When you get the error click Debug, goto View>Call Stack (CTRL+L).
What's listed there?
6456456456.png This is all the call stack will let me see without scrolling
EDIT** Would you like me to paste ALL of my code?
That means the Change event of Sheet1 is being called over and over again.
To stop that happening you need to disable events as I suggested.
Is the code you posted for Sheet1?
If it is how did you try what I suggested?
PS Can you post the code instead of a picture?
Here is the entirety of my code
I tried what you told me to do, but I deleted it because it didn't do anything. "sheet1" I just deleted, because I do not need it, the code is all for "Hartland"Please Login or Register to view this content.
If I haven't answered anything or if you need clarification, let me know! Thanks!
How did you try what I suggested?
Also, where is the code you posted located?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks