Macro problem - loops theough user defined functions not called in macro

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Originally Posted by mehmetcik

You have an error in your code.

Enable errors and alerts and Screen Updates

Then step through your code

It normally happens at Match, Find Open etc.

So you could insert

Please Login or Register  to view this content.

before match and

Please Login or Register  to view this content.

after match

Ahh you are expecting an error with match. I guess that will be your problem.

Ahh, I thought the ErrHandler would do something. I'll try your suggestion, thanks for the prompt reply!

I fixed the code some head scratching and reviews of many helpful forum posts. The problem with the loop was rows added during the loop weren't included. Also I used resize to add rows which worked better with more than 1 row to add (for example below).

Please Login or Register  to view this content.

The code works but still loops through the User Defined Functions (as do some other macros in the workbook). This makes the code run more slowly. Its not too much of a problem but I wondered if there was a way to stop it? Thanks for any advice.

I see what you have done mehmetcik! A clever workaround that I would not have thought of. Thanks very much for your quick response!

gbeats101, that might be what it is. I have used the UDFs in formulas but on a different sheet. They list unique values and concatenate lists, I'll give it a try.

Thanks for the advice.