rows and columns set in cm Free Excel Macros (VBA) | Excel Programs

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
Sub satir() 
Dim yukseklik As Single, mevcut As Single, text As String, cevap As String 
'mevcut satır yüksekliğini bul 
mevcut = Selection.RowHeight / 29.5 
'mesaj içriğini hazırla 
text = "Mevcut satır yüksekliği: " & Format(mevcut, "###0.00 cm") & Chr(13) & "Yeni satır yüksekliğini girin (cm):" 
'InputBox göster 
cevap = InputBox(text, "Yeni satır yüksekliği belirle", Format(mevcut, "###0.00")) 
'cevaba göre yeni satır yüksekliği değiştir 
If cevap  "" Then 
yukseklik = CSng(cevap) 
Selection.RowHeight = yukseklik * 29.5 
End If 
End Sub

Sub sutun() 
Dim genislik As Single, mevcut As Single, text As String, cevap As String 
'mevcut sütun genişliğini bul 
mevcut = (Selection.ColumnWidth + 0.71) / 5.1425 
'mesaj içriğini hazırla 
text = "Mevcut satır genişliği: " & Format(mevcut, "###0.00 cm") & Chr(13) & "Yeni sütun genişliğini girin:" 
'InputBox göster 
cevap = InputBox(text, "Yeni satır genişliğini girin (cm)", Format(mevcut, "###0.00")) 
'cevaba göre yeni sütun genişliğini değiştir 
If cevap  "" Then 
genislik = CSng(cevap) 
Selection.ColumnWidth = -0.71 + 5.1425 * genislik 
End If 
End Sub

No	Macro Name
1	rows and columns set in cm
2	Specify row height and column width in cm
3	codes to manually select the rows and columns you want to print
4	Coloring Rows and Columns
5	to delete sales with faulty cells
6	a macro with rows and columns
7	delete duplicate / duplicate rows
8	Clicking column c expands and narrows when you click another cell
9	prints all sheet / pages with data or scans but does not print
10	Expand the selected area by one more cell fill the old region with more cells
11	row column hiding 2
12	selection of filled fields and finding the last filled cell
13	gif vs. jpg placing the picture between cells
14	Copy and paste cell values by shortcut
15	Highlight Specific Text: Suppose you have a large data set and want to control a specific value. You can use this code for this. When you run, you receive an input box to enter the value to search for.
16	VLOOKUP formula or function with 3 (three) parameters
17	status bar macro with a message waiting
18	active cell printing
19	Track and Report User Changes in an Excel worksheet or workbook
20	printing and prompting

Excel Free Macros (VBA)

Rows And Columns Set İn Cm

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords