Excel Tips and Tricks

 This is a short collection of general Excel tips which don't fall into any other category

 - CSV Separator Hack
 - Named Range Tricks
 - Unprotect WorkSheets
 

• Excel Named Range Tricks
• Excel Calling Subs with Parameters from a Worksheet
• Excel Unprotect WorkSheets
• Disable VBA IDE Error Popup
• VBA Passing Parameters to Methods from Worksheet Buttons
• Bulk Add Apostrophes to Cells