Runtime error '28'..... out of stack space solution!!

Is there any other code resides in your workbook?

You have to disable events before updating the contents of the sheet otherwise the event will fire again.
As your code does not check what cell is changing the event fires and executes the code every time a change happens.

Please Login or Register  to view this content.

You need to post a file then as it works for me.

Originally Posted by meus

Hey sixth sense!! i have a macro but don't have other codes in main sheet..

Andy fixed your issue so try Andy's solution

I thought I had in my post.

The event fires every time a cell on the sheet changes. Inside the event you change a cell cause the event to fire again. This keeps happening until it runs out of stack space.

The code I added turns off the event listening whilst you update the sheet from within the event routine