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 “” 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…

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

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 List of Excel Keyboard Shortcuts for Windows and Mac. # Action Shortcut 1 Help F1 2 Object Browser F2 3 Find F3 4 Properies Window F4 5 Run…

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, OK, let’s start the case. Source Data Rebuild Data INDEX formula You might think use INDEX() function, right! but how? The INDEX() function syntax: INDEX(array, row_num, [column_num]) After…

How To Quickly Insert Blank Rows Between Existing Rows In Excel

Sometimes, you may need to dynamically insert blank rows between each of the existing rows into your Worksheet. Although blank rows are generally bothersome, in some situations, the final formatted version of your report requires them to separate data. This tip will help you quickly insert blank rows between multiple…