VBA Out of Stack Space Error 28

I have a drop down list with 8 options. When you select an option I want data from another sheet on the workbook to be copied and pasted onto sheet one. I have done this using 8 separate macro's I recorded. Any help would be great? See below my code:

Please Login or Register  to view this content.

Hi, and welcome to the forum. UnfortunatelyYour 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

Since this is your first post I'll change it for you but please note for the future.

This is difficult to answer with certainty since we have no ideas what your macros are doing. I'm guessing that there is a lot of looping with variable values being popped into the memory stack without being removed thus overloading it. So upload your workbook so that we may see your request in context.

It's also likely that if you are using loops there might be a more efficient method using perhaps filtering.

Turn off events at the start of the code and turn them back on at the end.

Please Login or Register  to view this content.

By the way, do you want this code to execute whenever any change is made in any sheet on any worksheet or only when a certain range/cell is changed?


PS Can you add code tags when posting code?

That code can be reduced to this.

Please Login or Register  to view this content.

This code will only get fully executed if F11 has been changed.

Please Login or Register  to view this content.

Just out of interest do the macros contain loops which are copying and pasting single rows each pass through the loop?