Specify row height and column width in cm <! - Setting Column Width and Row Height In Centimeters mm cm width increment reduction change -> Free Excel Macros (VBA) | Excel Programs

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
Sub SetColumnWidthMM(ColNo As Long, mmWidth As Integer)
'Set the columnwidth in millimeters (approximately)
Dim w As Single
If ColNo < 1 Or ColNo > 255 Then Exit Sub
Application.ScreenUpdating = False
w = Application.CentimetersToPoints(mmWidth / 10)
While Columns(ColNo + 1).Left Columns(
ColNo).Left 0.1
> w
Columns(ColNo).ColumnWidth = _
Columns(ColNo).ColumnWidth 0.1
Wend
While Columns(ColNo + 1).Left Columns(
ColNo).Left + 0.1 < w
Columns(ColNo).ColumnWidth = _
Columns(ColNo).ColumnWidth + 0.1
Wend
End Sub
Sub SetRowHeightMM(RowNo As Long, mmHeight As Integer)
'Set the rowheight in millimeters
If RowNo < 1 Or RowNo > 65536 Then Exit Sub
Rows(RowNo).RowHeight = _
Application.CentimetersToPoints( _
mmHeight / 10)
End Sub
The sample macro below shows how you can change the column width of column C and the row
height of row 3 to 3.5 cm:
Sub ChangeWidthAndHeight()
SetColumnWidthMM 3, 35
SetRowHeightMM 3, 35
End Sub

No	Macro Name
1	Specify row height and column width in cm
2	excel operators hk
3	you specify the row and column width
4	specifies in detail how many references the book contains (on new sheet / page)
5	Automatically resize row width when cells are merged
6	specifies in detail how many formulas are in the book (on new sheet / page)
7	rows and columns set in cm
8	list formulas on new sheet / page
9	printing and prompting
10	active cell printing
11	a lot of dialog windows
12	gif vs. jpg placing the picture between cells
13	inserts months as sheet / pages Specifies days in detail
14	listbox filtering
15	userform perfect opening effect
16	Can the characters typed in the inputbox appear as "*****" (password or password characters)?
17	Adjust or change column width and row height together
18	Open a new worksheet with a name entered in textbox1
19	deleting selected row in listbox
20	delete the selected cell from the listbox.

Excel Free Macros (VBA)

Specify Row Height And Column Width İn Cm

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords