Siang master2 semua, saya membuat script hapus seluruh data cell terpilih sbb:
Dim Ws As Worksheet Dim Kode As Variant Dim C As Range If MsgBox("Apakah Anda Yakin Akan Menghapus Data? " & txtNama.Text, vbYesNo + 48, "Pesan") = vbYes Then Set Ws = Worksheets("CopyData") Kode = Me.txtNomorInduk.Value With Ws.Range("B2:B20") Set C = .Find(Kode, LookAt:=xlWhole) If Not C Is Nothing Then m_lRowIndex = C.Row Ws.Cells(m_lRowIndex, 1).Value = "" Ws.Cells(m_lRowIndex, 2).Value = "" Ws.Cells(m_lRowIndex, 3).Value = "" Ws.Cells(m_lRowIndex, 4).Value = "" Ws.Cells(m_lRowIndex, 5).Value = "" Ws.Cells(m_lRowIndex, 6).Value = "" C.EntireRow.Delete End If End With End Sub
Nah yang ingin saya tanyakan, bagaimana agar nomor urut kembali berurutan sekalipun datanya sudah dihapus. (lih. Gambar berawarna merah)
Thanks