How do i solve error '28': Out of stack space

**Melissa Camp** · 12-17-2015, 05:38 PM

I am using the macro below and getting this error:

Run-time error '28':
Out of stack space

Is there a solution to this? The macro looks for blank columns from Col 'B' to 'BA' and if the cell is blank it copies the preceding row data into the empty cells beneath it.

Here is the macro:

Please Login or Register  to view this content.

**protonLeah** · 12-17-2015, 06:08 PM

code tags added

**Melissa Camp** · 12-17-2015, 08:01 PM

My mistake, thank you.

**Trebor76** · 12-18-2015, 01:43 AM

Hi Melissa,

Did I write that code? Looks like my work

How many rows are we talking about? I have run into strive with the Evaluate function when it's called over and over again as would be the case here. Assuming that is the problem, see how this goes:

Please Login or Register  to view this content.

Regards,

Robert

**Melissa Camp** · 12-18-2015, 12:59 PM

Robert- This did the trick. THANK YOU!!

**Trebor76** · 12-18-2015, 05:42 PM

You're welcome. Thanks for marking the thread as solved

How do i solve error '28': Out of stack space

LinkBack

Thread Tools

Rate This Thread

Display

How do i solve error '28': Out of stack space

Re: How do i solve error '28': Out of stack space

Re: How do i solve error '28': Out of stack space

Re: How do i solve error '28': Out of stack space

Re: How do i solve error '28': Out of stack space

Re: How do i solve error '28': Out of stack space

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Error 28 Stack Space

VBA Out of Stack Space Error 28

Out of stack space error

Run Time Error 28: Out of Stack Space

Run-time error '28' Out of stack space

Out of stack space error

[SOLVED] 'Out of stack space' error on SaveAs

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions