I'm trying to help Gunther with this post
http://www.excelforum.com/excel-gene...g-as-such.html
but my code loops around a second time giving an error. How do I prevent this?So it correctly adjusts the cell then gives an error because it tries to do it to the next cell (I believe). Thanks in advance.
Please Login or Register to view this content.
Last edited by ChemistB; 03-09-2011 at 04:31 PM.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
to the beginning of that sub add - Application.enableevents = false
and then to the end of it add - Application.enableevents = true
That'll stop the Worksheet_Change event from running a second time when you make the change
Did you try turning EnableEvents off at the start of the macro and back on at the end?
Ben Van Johnson
The mistakes of a beginner. Thanks !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks