Procedure too large

Respected Sir/Madame
I made this code for update table's data to another range of tables. but when it runs it says Procedure Too Large. in my full code it has 4000+ lines ,please help me to resolve this. (i need this code to runs in 32bit Excel 365 )

Thank you very much.

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. 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, and it also maintains VBA formatting.

Click on Edit to open your post, then 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

(Note: this change is not optional. As you are new here, I have added them for you this time.)

okay sorry for the mistake.

Instead of someone here trying to interpret what you are doing in the code (a laborious task), please explain in simple English what you are attempting to do. In this manner, it may be possible to offer an alternative solution instead of trying to repair what you already have.

Your uploaded workbook contains no data nor any explanation of your required actions. Help us to help you by telling specifically what is supposed to happen.

You appear to be repeating this chunk, just with a different offset each time:

Please Login or Register  to view this content.

so you should make that a separate routine that takes the offset as an argument:

Please Login or Register  to view this content.

then your code sections above reduce to:

Please Login or Register  to view this content.

and so on.