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)


Convert Date To Years: This Code Converts Dates İnto The Year Of The Month.

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 Date to Years: This code converts dates into the year of the month.
2 excel operators hk
3 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.
4 Converting to Suitcase: And this code converts the selected text into the correct word that fills the first letter of capital with lowercase letters.
5 separates the text in the active cell into letters (columns)
6 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.
7 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.
8 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.
9 Convert to Uppercase: Select cells and run this code. Checks each cell of the selected range and then converts it to uppercase text.
10 divides the text in the active cell into letters (divided by 3 characters into columns)
11 write the days of this month to the right write the day to the child cell and color the weekends
12 finds the last day of the month writes to the active cell
13 Â Graphics Use these VBA codes to manage graphics in Excel and save a lot of time. & Nbsp; Change Chart Type: This code will help you convert the chart type without using the chart options on the tab. All you need to do is specify which type you want to convert. & Nbsp; The following code converts the selected chart to a clustered column chart. There are different codes for different types, where you can find all these types.
14 convert double and single lines into different colors and designs (one line is bold and the other line is normal)
15 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.
16 Can the characters typed in the inputbox appear as "*****" (password or password characters)?
17 translate the number / number into English (in dollars and cents)
18 lists all macros in macros in excel files in a folder of your choice
19 Print Custom Pages: You can use this code to print a range of custom sheet / pages instead of using the setting from the print options. Suppose you want to print sheet / pages 5 to 10. Just run this VBA code and enter the start sheet / page and end sheet / page.
20 Inputbox add year as summer


aaaaa