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)

---

Deletes Data

Online Excel and Excel Macro (VBA) Courses

Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php VERİLERİ SİLER Private Sub CommandButton7_Click() Dim say As Integer Dim i As Integer Dim bos As Range For Each bos In Range("B1:B" & WorksheetFunction.CountA(Range("B1:B65000"))) If ComboBox1.Value = "" Or bos = "" Or ActiveCell = "" Then MsgBox "Önce aradığınız veriyi BUL ile bulmalısınız" Exit Sub End If Next bos Range(ActiveCell.Offset(0, -1).Address(False, False) & ":" & ActiveCell.Offset(0, 2).Address(False, False)).Delete Shift:=xlUp say = WorksheetFunction.CountA(Range("A2:A65000")) For i = 1 To say Cells(i + 1, 1) = i Next i Workbooks("kitap2.XLS").Save MsgBox "Veriniz Silindi", , "KAYIT" ComboBox1.RowSource = "Veri!B1:B" & say + 1 TextBox1.Value = WorksheetFunction.Count(Range("A1:A65000")) + 1 Unload UserForm1 UserForm1.Show End Sub

Report problem with this macro

This macro does not work.
There's an error in the code.
Other
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

No	Macro Name
1	deletes data without breaking the formula
2	warns and deletes data when data is entered in the active sheet / page
3	deletes data
4	code that automatically deletes asynchronous data
5	write to the cell delete the range of data to be deleted (deletes from sheet / page1 and sheet / page2 on sheet / page1 to a2b2)
6	Adds sheet / pages based on data in column A and writes data up to column D
7	Delete Data Dialog Window
8	delete data from listbox
9	delete every 5 min without warning if there is data between a1: a3000
10	check the same data on the active sheet / page
11	a1e force to enter date with vba
12	clears data on the sheet / page except the sheet / page you want
13	Cells a1 to a3000 make red if there is any data and send the line completely to sheet / page 3
14	write the days of this month to the right write the day to the child cell and color the weekends
15	excel operators hk
16	Delete that row if the data in column a and c are the same
17	delete selected data and row in combobox
18	Delete rows that match a specific criterion
19	get information from the registry
20	Deletes the top empty cells from the last full cell on the Worksheet

---

---

Online Excel Courses

Online Excel Courses are here...

Click to see

Services

• Advanced Excel Courses
• Excel Macro Courses
• Comporate Valuation Courses
• Financial Mathematics
• Financial Modeling
• Comporate Valuation Services

How can we help you?

You can contact us about our services.

Contact us

Subscribe to our Youtube Channel?

Here are the videos that will make your life easier using Excel.

Subscribe Now

Keywords

Excel Videos Advanced Excel Courses Free Macros Free Excel Templates Excel Macro Courses