cell-related codes Free Excel Macros (VBA) | Excel Programs

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
EĞER A SÜTUNUNDA KIRMIZI HÜCRE VARSA İLGİLİ SATIRI SİLEN KODLAR (COLOR İNDEK = 3 :Kırmızı)
Sub kirmizisil()
Sub DeleteRowsRedInColA()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual 'pre XL97 xlManual
Dim rng As Range, ix As Long
Set rng = Intersect(Range("A:A"), ActiveSheet.UsedRange)
For ix = rng.Count To 1 Step -1
If rng.Item(ix).Interior.ColorIndex = 3 Then 'rakamı değiştirebilirsiniz
rng.Item(ix).EntireRow.Delete
End If
Next
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
DOLU HÜCRELERİN SATIRINI MAVİ BOŞLARI İSE SARI YAPAN KODLAR
Sub bosdolurenklendir()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim cell As Range
For Each cell In Intersect(Selection, ActiveCell.EntireColumn, _
ActiveSheet.UsedRange)
Select Case cell.Value
Case Is >= 50
cell.EntireRow.Interior.ColorIndex = 20
Case Is >= 40
cell.EntireRow.Interior.ColorIndex = 37
Case Is >= 20
cell.EntireRow.Interior.ColorIndex = 38
Case Is >= 0
cell.EntireRow.Interior.ColorIndex = 36
Case Else
cell.EntireRow.Interior.ColorIndex = 44
End Select
Next cell
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
A1:B10 HÜCRELERİNDEKİ DEĞER 10 DAN BÜYÜK İSE HÜCRE RENGİ SARI OLUR
Private Sub Worksheet_Change( _
  ByVal Target As Excel.Range)
  If Intersect(Target, Range("A1:B10")) _
    Is Nothing Then Exit Sub
  If Target.Value > 10 Then
    Target.Interior.ColorIndex = 6
  Else
    Target.Interior.ColorIndex = xlNone
  End If
End Sub

No	Macro Name
1	cell-related codes
2	The following are the codes that list the data on the report sheet / pages to the report sheet / page in the selected date range.
3	CODES PRINTED AS AN EXPLANATION FORMULATIONS IN CELLS
4	codes that write text in active cells as comments
5	find-delete-change-save codes2
6	Codes that prevent and open the vba window and access codes
7	Coloring a cell with rgb codes
8	prevents codes from failing
9	indis (Index) function as vba code
10	Highlight Unique Values: These codes will highlight all cells with a unique value in the selection.
11	Printing These macro codes help you automate some print tasks that will save you more time. & Nbsp; Print Comments: Use this macro to enable settings to print cell comments at the end of the sheet / page. Suppose you have 10 sheet / pages to print, and after using this code you will receive all comments on sheet / page 11.
12	CODES COLLECTING NUMBERS IN ACTIVE CELL
13	error message in macro codes
14	Â 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.
15	register codes comparing first and last name
16	Numbers and codes from a1 to b1
17	find-delete-change-save codes
18	Â 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.
19	enter the password to activate the codes again
20	deleting all the codes we have written in the excel file

Excel Free Macros (VBA)

Cell-related Codes

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords