View Single Post
 
Old 06-10-2016, 11:35 AM
gmaxey gmaxey is offline Windows 7 32bit Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,598
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

The reason you got the error was because you didn't enter anything into the CC (it was showing placeholder text) so there was no range.characters.first to format.

Error handling can be used to get around that, but another method is to evaluate if the condition exists that caused the error exists and if it does, don't perform the action that causes the error.
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote