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

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 […]

9 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 […]

0 VBA LCASE Function – Convert Text to Lower Case in Excel

VBA LCase to convert selection to lower case

In Excel worksheet, there is a LOWER function that converts a text string into lower case. Just like the LOWER function, there is a similar inbuilt function in Excel VBA – LCASE The VBA LCASE function takes a string as the input and converts it into a lower case string. Syntax of VBA LCASE Function […]

1 How to Move Rows and Columns in Excel (The Best and Fastest Way)

Sometimes when working with data in Excel, you may have a need to move rows and columns in the dataset. For example, in the below dataset, I want to quickly move the highlighted row to the top. Now, are you thinking of copying this row, inserting the copied row where you want it, and then […]

0 Excel VBA TRIM Function (explained with Examples)

Excel already has a TRIM worksheet function that you can use to get rid of leading, trailing, and extra spaces in between words/strings. There is a TRIM function in VBA as well (and it does exactly the same thing – remove extra spaces). Why do we need a TRIM function in VBA too? Fair question! […]

0 How to Create an Area Chart in Excel (explained with Examples)

An area chart is similar to a line chart with one difference – the area below the line is filled with a color. Both – a line chart and an area chart – show a trend over time. In case you’re only interested in showing the trend, using a line chart is a better choice […]

« Previous 1 2 3 4 … 50 Next »