Microsoft Query Error: "This data source contains no visible tables."
When you import data by using the Microsoft Query Wizard and choose Excel Files as data source, you may receive the following […]
Complete List of Excel VBA Editor Keyboard Shortcuts
The complete list of Excel VBA Editor (VBE) keyboard shortcuts are for U.S. keyboard layout and Windows Operation system. See also: Complete […]
Find and Select the First Blank Cell in a Column VBA
Sometimes, You may need to find and select the first blank cell or last blank cell in a column, these macros can […]
How to Rebuild Data, Case Study
Sometimes we deal with data that is not standardized that we might give up, you should learn how to rebuild you data, […]
Find and Format All Formulas in a Workbook
This simple macro can help find and format all cells that contain formulas. VBA Code Sub FormatFormulas() 'Step 1: Declare your Variables […]
Delete Blank or Empty Columns Use Excel VBA
Blank columns can often cause problems with formulas. If you find that you are manually searching out and deleting blank columns in […]
Delete Blank or Empty Rows Use Excel VBA
Blank rows can often cause problems with formulas. If you find that you are manually searching out and deleting blank rows in […]
Unhide All Rows and Columns
This simple macro automatically unhides all rows and columns for you. VBA Code Sub UnhideAll() Columns.EntireColumn.Hidden = False Rows.EntireRow.Hidden = False End […]