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

    Tips & Tricks, VBA  4573 0

In VBA, strings assigned to variables or properties are enclosed in double quotes “”, Sometimes you might want to place Double Quotes “” in a string in Excel VBA. For example: A1 =IF(B1=”Excel”,B1,””) In VBE, you can replace ” with “”, and then enclose the entire string =IF(B1=””Excel””,B1,””””) in double quotes…

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

    VBA  8187 5

The following Excel VBA code can help you to list all files in folder and sub-folders into a worksheet. VBA Code How to Use This Macro To use this macro, you can copy and paste it into a standard module: Activate the Visual Basic Editor by pressing ALT+F11. Right-click the project/workbook name in…

Sort Column Data By Double Clicking Header Cell Use Excel VBA

    VBA  5072 1

If you want to sort the column data in ascending or descending order by double clicking on any Excel column header, you will need the following VBA code. See the screenshot: VBA code You can download the working example: Sort Column Data By Double Clicking Header. How to Use This…

limit Scroll Area on an Excel Worksheet

    Tips & Tricks  23446 0

Sometimes, if you want to limit scroll area of an Excel worksheet, it means that the cells outside the scroll area cannot be selected. Are there any quick tricks to limit the scroll area on an Excel worksheet? Limit Scroll Area by Entering the Range Address Manually Open the workbook….

Limit Scroll Area Use Excel VBA

    VBA  16096 4

The following VBA code can help you to limit the scroll area for a particular worksheet. VBA code Excel’s ScrollArea property allows you to set the scroll area for a particular worksheet. For instance, this statement sets the scroll area on Sheet1 so the user cannot activate any cells outside…