I need help!

[ChrisB2011]

I am trying to use a paste special that works when an input in my spreadsheet is changed, but for some reason I get into an iterative loop and then crash excel. Can someone tell me why this code doesn't work? And possibly offer suggestions.

Please Login or Register  to view this content.

[StevenM]

You need to add:

Please Login or Register  to view this content.

At the beginning and then:

Please Login or Register  to view this content.

At the end.

What happens is that when you write to this worksheet, you changed it, so it calls the Worksheet_Change again.

[romperstomper]

This line:

Please Login or Register  to view this content.

should presumably be

Please Login or Register  to view this content.

since it serves no purpose at the moment.

[ChrisB2011]

Thanks Steven!

I've been messing with this sheet for hours now and that worked perfectly.

[ChrisB2011]

Thanks for the help romperstomper! This is only my first thread, but I feel like I'm going to learn a lot on here.