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

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

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

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

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

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

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

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