Excel Blog - Latest Excel tips, tutorials, and videos.

0 VBA DIR Function – An Easy Explanation with Examples

VBA has some useful functions that can take your automation in Excel to the next level. One such function is the VBA DIR function. While by itself, it may seem like a simple function that does one specific thing. But when you combine it with some other useful elements of the VBA coding language, you […]

1 How to Sort Worksheets in Excel using VBA (alphabetically)

Copy and Paste the code to sort worksheet tabs in Excel

If you work with a lot of worksheets in Excel, you would know the management of it can become an issue. Once you have more than a couple of worksheets, you need to manually arrange these. How easy would it be had there been a way to quickly sort the worksheets in Excel. While there […]

0 6 Easy Ways to Insert the Delta Symbol (Δ) in Excel

When it comes to inserting symbols in Excel, things can get a bit complicated. You either need to know the keyboard shortcut, or use the methods that are not very straightforward. And there are a lot of symbols that many people need to insert regularly, such as the degree symbol, cent symbol, delta symbol, etc. […]

0 Excel VBA Select Case Statement – Explained with Examples

Select Case Statement in Excel VBA - Get Grade Custom Function

Excel VBA has the IF Then Else construct that you can use to analyze multiple conditions and execute codes based on these conditions. Another similar construct that allows you to check for multiple conditions is the SELECT CASE statement. Select Case is useful when you have three or more conditions that you want to check. […]

0 Understanding Excel VBA Data Types (Variables and Constants)

Excel VBA Data Types assignment error mismatch

In Excel VBA, you would often be required to use variables and constants. When working with VBA, a variable is a location in your computer’s memory where you can store data. The type of data you can store in a variable would depend on the data type of the variable. For example, if you want […]

12 8 Ways to Reduce Excel File Size (that actually work)

Excel workbooks have been known to become painfully slow and heavy as more data/formulas/images are added to it. Sometimes, it’s easy to get rid of the extra flab and keep the excel file size in check, and sometimes, it isn’t. And since Excel is not a web-based tool, most of us work and collaborate by […]

0 VBA UCASE Function – Convert Text to Upper Case in Excel

Excel VBA Ucase Function Example - Message Box

In Excel worksheet, the UPPER function converts all the lowercase characters of a text string into uppercase. There is a similar function in that also does the same – the UCase function. The VBA UCase function takes a string as the input and converts all the lower case characters into upper case. Syntax of the VBA UCASE Function […]

« Previous 1 2 3 4 … 51 Next »