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)


Suspended Cells: Select The Cells And Run This Code; Remove All The Cells İn The Selection With The Data You Lost.

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 Suspended Cells: Select the cells and run this code; remove all the cells in the selection with the data you lost.
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 identifying unique (single) data entries
5 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.
6 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.
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 Highlight Cells with Wrong Words: This code is for you if it becomes difficult to check all cells due to typos. It controls each cell in the selection and highlights the cell with a misspelled word.
10 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.
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 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.
13 Finding the Number of Each Item in the List Using the VBA and Pivot Table
14 Replace Empty Cells with Zeros: You can add zeros to data where you have empty cells. The formula makes it easier to use and use these cells in advanced accounts.
15 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.
16 AutoFit Rows: You can use this code to automatically fit all rows in a worksheet. When you run this code, it selects all the cells in your worksheet and fits almost all rows automatically.
17 inserts months as sheet / pages Specifies days in detail
18 writes the names of all sheet / pages from the active sheet / page and cell and adds a link to the sheet / pages
19 summer adds months to sheet / pages
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