Category: VBA macros

Combine multiple columns data to single column [Excel VBA]

combine-multiple-columns-data-to-single-column-excel-vba

If you want to combine multiple columns data to a single column using excel VBA, then use below code. Below macro combines data of 10 columns and displays it in first column. Change numOfColumns variable value as per your requirement.

Remove blank rows inside cell [excel VBA]

remove-blank-rows-inside-cell-excel-vba

We can create new line/row inside a cell by pressing ALT+ENTER in MS Excel. If you come across a situation where you want to remove blank rows/lines inside the cell, then you can’t remove them using trim method. Below code helps you to remove them automatically using VBA code.

In the above code Chr(10) […]

[Excel VBA code] Convert a string to Uppercase letters

excel-vba-convert-string-to-uppercase-output

Excel VBA code to convert a string to uppercase letters. It converts all lowercase letters to uppercase.

Output:

VBA code to capitalize each word of a string [Excel]

capitalize-each-word-string-VBA-excel

Below is the Excel VBA code to capitalize each word of a string.

Output:

VBA macro to find duplicates in excel

macro-duplicates-highlighted-in-red

VBA macro to find duplicates in excel sheet. This macro finds the duplicates in user selected range and highlights them in light red color. VBA code to find and highlight duplicates

Add above code to your excel workbook How to use this macro Select the range (column/row/columns and rows…) in which you want to […]

Macro to extract file name from file path [Excel VBA]

Excel VBA macro to extract file name from file path. This macro extracts the string (file name) which is between dot (.) and backslash(\) delimiters (from right side).

Page 1 of 3123