clears data on the sheet / page except the sheet / page you want Free Excel Macros (VBA) | Excel Programs

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
Sub Sayfalarısıfırla() 
'/_ 
'İstediğiniz sayfa hariç diğer sayfadaki verileri temizler 
'a.küçükkaya / pir

Dim i As Integer 
For i = 1 To Sheets.Count 
If Worksheets(i).Name  "Rapor" Then 
Worksheets(i).Cells.Delete 
Selection.Style = "Normal"       'hücreyi reset eder yani ilk açılıştaki haline çevirir 
End If 
Next i 
End Sub                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               Resimleri de silmek için ilave edin                                                                                                                                                                         For j = 1 To Shapes.Count 
Shapes(j).Delete 
Next j -

No	Macro Name
1	clears data on the sheet / page except the sheet / page you want
2	excel operators hk
3	prints all sheet / pages with data or scans but does not print
4	print button Do you want to preview the sheet / page to be printed
5	remove sheet / page protections
6	number of sheet / page prints with message box (prints even if the sheet / page is blank)
7	Print Custom Pages: You can use this code to print a range of custom sheet / pages instead of using the setting from the print options. Suppose you want to print sheet / pages 5 to 10. Just run this VBA code and enter the start sheet / page and end sheet / page.
8	hides all sheet / pages and shows the sheet / page you want and vice versa
9	write the number you want to be colored on the sheet / page in msgbox
10	Do you want the active cell to go to the top of the sheet / page?
11	userformless form menu sheet / page select
12	sheet / pages showing userform (with code without form)
13	The following are the codes that list the data on the report sheet / pages to the report sheet / page in the selected date range.
14	goes to the sheet / page you want
15	b3e enter data insert web sheet / page as sheet / page
16	inserts the date and time when data was entered into the cells where data was entered on the active sheet / page as a comment
17	output as a word sheet / page
18	giving sheet / page insertion sequence number
19	When 1 is entered in the cell on your sheet / page, the sentence corresponding to one is automatically written.
20	double click to go to the sheet / page I want

Excel Free Macros (VBA)

Clears Data On The Sheet / Page Except The Sheet / Page You Want

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords