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)


Remove Decimals From Numbers: This Code Helps You Remove All Digits Of The Digits İn The Selected Range.

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 Remove Decimals from Numbers: This code helps you remove all digits of the digits in the selected range.
2 excel operators hk
3 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.
4 remove sheet / page protections
5 Remove Text Wrap: This code will help you remove text wrap across the entire worksheet with a single click. first selects all columns and then removes the text wrap and automatically fits all rows and columns.
6 Add menu to file edit bar delete
7 calculator on / off
8 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;
9 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.
10 Remove the abbreviation from Number One: Run this code to remove it if you have numeric data with an apostrophe before each number.
11 Remove Negative Marks: This code checks all cells in the selection and makes all negative numbers positive. Select a range and run this code.
12 Delete all modules in an Excel file at the same time
13 get information from the registry
14 Remove Date Time: You can use this code if you are spending time with the date and want to remove it.
15 Export selected cells to text file
16 Can the characters typed in the inputbox appear as "*****" (password or password characters)?
17 Â AdvancedSome of the code you can use to prepare an advanced task in your electrical tables. Select the selected Range as PDF: Select a range Run this macro and obtain a PDF file for the selected range. This is really cool.
18 Suspended Cells: Select the cells and run this code; remove all the cells in the selection with the data you lost.
19 Â 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.
20 Listing Subprograms in a Workbook


aaaaa