+ EXCEL

Sub HARF_RAKAM_AYIR()

Dim sh As Worksheet, hc As Range, ss As Integer

Set sh = ThisWorkbook.ActiveSheet

ss = sh.Range("A:D").Find("*", , , , xlByRows, xlPrevious).Row

For i = 2 To ss

Set hc = sh.Range("A" & i)

For d = 1 To Len(hc.Value)

If IsNumeric(Mid(hc.Value, d, 1)) = False Then

harf = harf & Mid(hc.Value, d, 1)

End If

If IsNumeric(Mid(hc.Value, d, 1)) = True Then

rakam = rakam & Mid(hc.Value, d, 1)

End If

Next d

hc.Offset(0, 1).Value = harf

Columns("C").NumberFormat = "@"

hc.Offset(0, 2).Value = rakam

harf = ""

rakam = ""

Next i

MsgBox "işlem tamam", vbInformation, "işlem sonucu"

End Sub

f2+enter

SUTUN = Application.InputBox("Sütun İsmini Yaz!", Application.UserName, "Sütun İsmini Buraya Yazınız.")
Range(SUTUN & 2).Select
For Each Alan In Range(SUTUN & 2 & ":" & SUTUN & Range("G1536").End(xlUp).Row) '
    SendKeys "{F2}", True
    SendKeys "{ENTER}", True
Next Alan
Range(SUTUN & 2).Select

Sub BosSatirlariSil()

Range(Range("A65536").End(xlUp), Range("A2")).SpecialCells(xlCellTypeBlanks).EntireRow.Delete

End Sub

Renkli hücrelerin değerlerini toplatmak için;

    
            
            Function RenkTopla(ByVal Alan As Range, rKodu As Integer) As Long
    '=RenkTopla(D4:D18;3)
    Dim H As Range
    Dim i As Integer
    Dim Sonuc
 
    For Each H In Alan
        If H.Interior.ColorIndex = rKodu Then
            Sonuc = Sonuc + H
        End If
    Next H
    RenkTopla = Sonuc
End Function

        

renk kodlarının neler olduğunu öğrenmek için;

    
            Sub RenkKodu20()
    Dim i As Integer
 
    For i = 1 To 20
        Range("a" & i).Value = i
        Range("a" & i).Interior.ColorIndex = i
    Next
 
End Sub

atlanan sayı listele

Sub EKSİK_DEĞERLERİ_LİSTELE()
    Columns(3) = ""
    Satır = 1
    For X = 1 To [A65536].End(3).Row
    Fark = Cells(X + 1, 1) - Cells(X, 1)
    If Fark > 1 Then
    For Y = 1 To Fark - 1
    Cells(Satır, 3) = Cells(X, 1) + Y
    Satır = Satır + 1
    Next
    End If
    Next
End Sub

vba koruma kaldır=insert-modul
---------------------

Kod:

Sub SifreAc()
 Dim i As Integer, j As Integer, k As Integer
 Dim l As Integer, m As Integer, n As Integer
 Dim i1 As Integer, i2 As Integer, i3 As Integer
 Dim i4 As Integer, i5 As Integer, i6 As Integer
 On Error Resume Next
 For i = 65 To 66
 For j = 65 To 66
 For k = 65 To 66
 For l = 65 To 66
 For m = 65 To 66
 For i1 = 65 To 66
 For i2 = 65 To 66
 For i3 = 65 To 66
 For i4 = 65 To 66
 For i5 = 65 To 66
 For i6 = 65 To 66
 For n = 32 To 126
   ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
   Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) _
   & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
   If ActiveSheet.ProtectContents = False Then
   MsgBox "One usable password is " & Chr(i) & Chr(j) _
   & Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) _
   & Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
   Exit Sub
   End If
 Next
 Next
 Next
 Next
 Next
 Next
 Next
 Next
 Next
 Next
 Next
 Next
End Sub