Select Case statement Executes one of several groups of statements, depending on the value of an expression. Syntax Select Case testexpression[ Case expressionlist-n [ statements-n ]][ Case Else [ elsestatements ]]End Select The Select Case statement syntax has these parts: Part Description testexpression Required. Any numeric expression or string expression. expressionlist-n Required if a Case appears. Delimited list of one or more of the following forms: expression, expression to expression, Is comparison operator expression. The To keyword specifies a range of Read More
Month: July 2020
How to Check Excel if Cell Contains Partial Text
To check if a cell contains specific text, you can use the ISNUMBER and the SEARCH function in Excel. There’s no CONTAINS function in Excel. 1. To find the position of a substring in a text string, use the SEARCH function. = SEARCH(B2,A2) Explanation: “duck” found at position 10, “donkey” found at position 1, cell A4 does not Read More
How to Print Multiple PDF Files Without Opening One by One
The PDF format preserves document formatting and protects data from being modified. These features make a PDF an ideal choice when saving completed business documents. When creating a complicated business report or compiling your business tax documents, it’s likely that you’ll quickly accumulate numerous PDF files that require printing. Rather than following the tedious process Read More
Mass Renaming Files or File Extensions
If you need to do some serious file renaming – perhaps you have folders stuffed with horribly named photos – try a bulk file renaming utility. There’s one called Bulk Rename Utility that’s free to use. It looks pretty ferocious when you open it up, but don’t worry – although it has enormous power and flexibility, it Read More
How to fix “Intel Optane Memory Pinning …” on Windows 10
How to Resolve Intel® Optane™ Memory Pinning Error: ‘Unable to load DLL ‘iaStorAfsServiceApi.dll” Encountered Original: https://www.intel.com/content/www/us/en/support/articles/000056299/memory-and-storage.html Validated. This solution has been verified by our customers to fix the issue with these environment variables Knowledge Content TypeError Messages Article ID000056299 Last Reviewed06/24/2020What are you seeing? After a Windows® 10 update, the following error message appears randomly Read More