Excel VBA Base64 HMAC SHA256 and SHA1 Encryption

VBA Base64 HMAC SHA256 and SHA1 To use this code, you need do this: Inside the VBE, Go to Tools -> References, […]

How to: Put Double Quotes in a String in Excel VBA

In VBA, strings assigned to variables or properties are enclosed in double quotes "", Sometimes you might want to place Double Quotes […]

How To List All Files In Folder And Sub-folders Use Excel VBA

The following Excel VBA code can help you to list all files in folder and sub-folders into a worksheet. Final update: Please […]

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 […]

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 […]

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 […]

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 […]

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 […]