EXCEL TIP: How to Break and Interrupt an Excel VBA Macro

If you want to break a VBA macro and stop it from  running or if your code is stuck in a loop just press the following hotkey: 

CTRL + BREAK 

(If you dont have the "Break" Key on your keyboard you can use the "On-Screen Keyboard" from Windows)

Created by DoMyExcel.com © | Excel & VBA Consulting | Customized Excel Solutions starting at 89 USD

Services provided to Individuals and Businesses | Free Quote: DoMyExcel@gmail.com

Excel Tip: Clear / Unfilter FILTERs Quickly

In Order to Clear / Unfilter a filter quickly you can use the Filter Hotkey Two Times :

Press 2 Times : CTRL + SHIFT + L 

Created by DoMyExcel.com © | Excel & VBA Consulting | Customized Excel Solutions starting at 29 USD

Services provided to Individuals and Businesses | Free Quote: DoMyExcel@gmail.com