Out of Stack space but can use F8 to step through no problem.

Originally Posted by COURTTROOPER

It is part of another Sub routine

I suggest you post all of the code, please.

See next post

Basically, your machine is running out of memory.

This error is most often caused by intense use of functions and sub calls (especially when it's nested in multiple layers). But could also be caused by registry error.

In your case, I'd imagine former to be more likely cause. Try breaking your sub into smaller subs. As memory is freed up when variable/function etc goes out of context (i.e. sub terminates).

Have a read of link as well.
https://docs.microsoft.com/en-us/off...space-error-28

cannot edit original input.

Original message:

Please Login or Register  to view this content.

Why am I not able to edit my posts? I get blank edit boxes.

Try this

Please Login or Register  to view this content.

Originally Posted by JLGWhiz

Why am I not able to edit my posts? I get blank edit boxes.

Forum bug - happens indiscriminately. I have reinstated one of your posts containing code. Hope this helps.

Tx AliGW
regards, JLG

It's not just changing Sign.Range() to .Range. But using With statement.

Code block is...

Please Login or Register  to view this content.

Sign is variable that's been set to object. By nesting .Range() inside 'With Sign' statement. You only need to write Sign once in With statement.
When nested members are preceded by "." it indicates that the member belongs to that object indicated in With block.

You can read more about it in link below.
https://docs.microsoft.com/en-us/dot...with-statement

However, I'm not sure how that impact memory usage. As it still holds same space in memory stack for the variable used.
Perhaps, by reducing code clutter, it freed up some memory. Or since object property need to be read only once... instead of multiple times... (to my understanding this only improves code execution speed and not memory optimization, but I could be wrong).

I am not sure I can explain it properly. You are using Sign as a sheet Name and as an object variable. This does have an effect on how the processor handles the data as the compiler interprets the code. I know that repeating the variable on each line of code froces the compiler to process the redundant entry over and over, each time distingruishing the variable from the sheet name. That could be causing an internal problem with the processor memory stack. I know that it is not a good practice to use the same text for a name and an object variable, just as it is not good practice to use key words like 'Cell' for a variable. But since they sometimes work, people continue to do it and then wonder what went wrong when problems arise because they used them.

Happy to assist,
regards, JLG