Junaid7861
New Member
- Joined
- Nov 8, 2023
- Messages
- 2
- Office Version
- 365
- 2016
- Platform
- Windows
Hi,
Please help mein this.
I have invoice format of 50 sheets these codes apply of worksheets
Vba Code
can row height & column width fixed that not drag from mouse or tool bar.
fonts Tahoma size 11 (A23:H29)
THEN THIS FORMULA IT WORKS PERFECT
ws.Columns("A").ColumnWidth = 11
ws.Columns("B").ColumnWidth = 20
ws.Columns("C").ColumnWidth = 8.71
ws.Columns("D").ColumnWidth = 5
ws.Columns("E").ColumnWidth = 5.29
ws.Columns("F").ColumnWidth = 11.43
ws.Columns("G").ColumnWidth = 10.43
ws.Columns("H").ColumnWidth = 16.57
' Set the row height for rows 23 to 42
ws.Rows("23:42").RowHeight = 22.5
FROM : JC
Please help mein this.
I have invoice format of 50 sheets these codes apply of worksheets
Vba Code
can row height & column width fixed that not drag from mouse or tool bar.
fonts Tahoma size 11 (A23:H29)
THEN THIS FORMULA IT WORKS PERFECT
ws.Columns("A").ColumnWidth = 11
ws.Columns("B").ColumnWidth = 20
ws.Columns("C").ColumnWidth = 8.71
ws.Columns("D").ColumnWidth = 5
ws.Columns("E").ColumnWidth = 5.29
ws.Columns("F").ColumnWidth = 11.43
ws.Columns("G").ColumnWidth = 10.43
ws.Columns("H").ColumnWidth = 16.57
' Set the row height for rows 23 to 42
ws.Rows("23:42").RowHeight = 22.5
FROM : JC