Excel Free Macros (VBA)


Number / Highlight Cells That Error İn 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 İt Will Return A Message Containing The Number Error Cells And Will Highlight All The Cells.

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 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.
2 excel operators hk
3 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.
4 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.
5 remove sheet / page protections
6 Create a user-defined menu / Create your own menu and assign a macro to them in the "Extensions" section
7 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.
8 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.
9 write the number you want to be colored on the sheet / page in msgbox
10 Create a Content Table: Suppose you have over 100 worksheets in your workbook. And now it is hard to navigate. Do not worry that this macro code will save everything. When you run this code, you will create a new worksheet and create a & nbsp; will create a directory.
11 Adding Serial Numbers: This macro code will help you automatically add serial numbers to your excel sheet. After you run this macro, it will display an input box where you must enter the maximum number for serial numbers, and then add a number to the column in a column.
12 opening calculator
13 a .bat file from a floppy disk
14 excelin all menu pushbutton pictures
15 list formulas on new sheet / page
16 specifies in detail how many formulas are in the book (on new sheet / page)
17 adding two lines and removing total
18 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.
19 specify the number of copies to print from the printer
20 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.


aaaaa