Hi
I have a workbook that logs our suppliers problems and I have created the following code
however occasionally is has an error loop how can i fix thisPlease Login or Register to view this content.
Hi
I have a workbook that logs our suppliers problems and I have created the following code
however occasionally is has an error loop how can i fix thisPlease Login or Register to view this content.
Can you be more specific? What is the error code? What line is highlighted when you debug? How often does it happen?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clicking below their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Hi
I get a circular reference warning when using, however no error on debug.
Last edited by mattdurbin; 11-29-2013 at 10:38 AM.
I'm guessing the problem is where you're trying to loop through all variants in a range. Like here:What exactly are you trying to accomplish?Please Login or Register to view this content.
Perhaps you may try this:
Please Login or Register to view this content.
thanks, that solved it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks