Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Excel Free Macros (VBA)


Text To Speech: Just Select A Range And Run This Code Excel Will Speak All The Text İn That Range From The Language Of The Cell.

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 Text to Speech: Just select a range and run this code excel will speak all the text in that range from the language of the cell.
2 excel operators hk
3 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.
4 Â Pivot Table These codes help you make and manage some changes to pivot tables in a flash. Hide Pivot Table Subtotals: If you want to hide all subtotals, simply run this code. first make sure that you select a cell from the pivot table and run this macro.
5 adding two lines and removing total
6 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.
7 Reverse Text: All you have to do is enterrvrse" in a cell and look at the cell that contains the text you want to reverse.
8 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.
9 Converting to Suitcase: And this code converts the selected text into the correct word that fills the first letter of capital with lowercase letters.
10 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.
11 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.
12 identifying unique (single) data entries
13 Remove One Character from Selection: You can use this code to remove a specific character from a selected cell. It will display an input box to enter the character you want to delete.
14 Highlight replicators from selection: This macro controls each cell of your selection and highlights duplicate values. You can also change the color of the code.
15 Count / Highlight Cells with a Specific feature on the entire worksheet: This code will help you count the cells that have a specific value to mention, and then highlight all of those cells.
16 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.
17 remove sheet / page protections
18 writes the names of all sheet / pages from the active sheet / page and cell and adds a link to the sheet / pages
19 Remove Characters from a Directory: Remove only characters from the beginning of a text string. All you need is to reference a cell or add a number of characters and text to the function to remove from the text string. There are two arguments,rng" for the text string andcnt" for the number of characters to remove. for example: 1 incnt if you want to remove the first characters from a cell;
20 Convert to Uppercase: Select cells and run this code. Checks each cell of the selected range and then converts it to uppercase text.


aaaaa