Excel Free Macros (VBA)


Convert Small Case: This Code Helps You Convert Selected Text To Lower Case Text. & Nbsp; Select A Range Of Cells That Contain Your Text And Run This Code. If A Cell Has Any Value Other Than A Number Or Text, The Value Will Remain The Same.

Copy Macro





You can write your comments about the error in the box below.
Report error

ALL MACROS Youtube Channel
The following macros may be useful for you.
Similar Results
NoMacro Name
1 Convert Small Case: This code helps you convert selected text to lower case text. & Nbsp; Select a range of cells that contain your text and run this code. If a cell has any value other than a number or text, the value will remain the same.
2 excel operators hk
3 Convert to Uppercase: Select cells and run this code. Checks each cell of the selected range and then converts it to uppercase text.
4 Find and select the remaining cell in the value between 2 selected numbers
5 Sentence story conversion: In the case of text, the first letter of the first word keeps the capital in a small case for all words. And this code helps you convert regular text into sentences.
6 Converting to Suitcase: And this code converts the selected text into the correct word that fills the first letter of capital with lowercase letters.
7 Convert Day to Day: if you have a date on your worksheet and want to convert all these dates into days, this code is for you. Just select the range of cells and run this macro.
8 Multiply All Values ​​by Number: You have a list and you want to multiply the entire number by a specific number. Just use this code. Select this range of cells and run this code. first, it will ask you the number you want to reach more than one person, and then all their numbers will be multiplied instantly.
9 Highlight Specific Text: Suppose you have a large data set and want to control a specific value. You can use this code for this. When you run, you receive an input box to enter the value to search for.
10 adding two lines and removing total
11 opening calculator
12 Convert selected cells to uppercase or lowercase with one click
13 Highlight Negative Numbers: Select a range of cells and run this code. It checks each cell of the range and highlights all the cells that you have a negative number.
14 Square Root Calculator: You can use this code to calculate the square root without applying a formula. checks all selected cells and converts numbers to square.
15 Calculate Cube Root: You can use this code to calculate the cube root without applying a formula. Checks all selected cells and converts numbers to cube roots.
16 Convert Roman Numbers to Arabic Numbers: Sometimes it is really hard to understand Roman numbers as serial numbers. This code will help you convert roman numbers to Arabic numbers.
17 translate the number / number into English (in dollars and cents)
18 convert double and single lines into different colors and designs (one line is bold and the other line is normal)
19 Collects cells that are red between a1: d20
20 Number / Highlight Cells that Error in the entire worksheet: This code will help you to highlight and count all the cells you have made an error with. Just run this code and it will return a message containing the number error cells and will highlight all the cells.


aaaaa