Reply to thread

Message: [QUOTE="Chip Pearson, post: 13519273"] That error means that some statement does not have a corresponding End statement. Just because the message says "Case" does not mean that it is necessarily the "Case" that is missing its End statement. Check all your If, Select, With statements to ensure that each has a corresponding End If, End Select, End With, etc. A quick review of your code leads me to the If statements in the block. Ensure that you have all the proper Else, ElseIf, and End If functions. If you get in the habit of properly indenting your code, such error become very simple to spot. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC [URL="http://www.cpearson.com"]www.cpearson.com[/URL] (email on web site) [/QUOTE]