Sort Column Data By Double Clicking Header Cell Use Excel VBA

If you want to sort the column data in ascending or descending order by double clicking on any Excel column header, you...
1

The ‘Microsoft.Jet.OLEDB.4.0’ provider is not registered on the local machine

For example, you have a 32-bit application (VBA, web app...) that uses the Microsoft OLE DB Provider for Jet. If you migrate...
2

How to Quickly Copy Values Without Formulas in Excel?

This article will guide you to quickly copy values without formulas in Excel. The example may be easier to understand if you...
1

limit Scroll Area on an Excel Worksheet

Sometimes, if you want to limit scroll area of an Excel worksheet, it means that the cells outside the scroll area cannot...
0

Limit Scroll Area Use Excel VBA

The following VBA code can help you to limit the scroll area for a particular worksheet. VBA code Excel’s ScrollArea property allows...
5

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...
10

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...
2

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...
18