Asked by duncanb7
at 2024-06-16 12:52:01
Point:250 Replies:4 POST_ID:828344USER_ID:11059
Topic:
Visual Basic Programming;;Microsoft Excel Spreadsheet Software
I have several question about cell and sheet formating and control in Excel by VBA coding
1-I would like to how set a specify Excell cell's width and height and other cells in the same sheet is not
affected. Please see the EE-1.xls example excel files. How to do such Excel inregular cell format by VBA coding
2- What I know at this part for format cells is only as follows code
Range("C1").Select
Selection.ColumnWidth = 30
Selection.RowHeight = 50
Sheet2.Columns(1).ColumnWidth = 100
Sheet2.Range("A1:E1").Columns.AutoFit
Do you have any good tutorial and VBA manual to mention all control sheet and cell command and function syntax website
for recommandation
Please advise
Duncan
1-I would like to how set a specify Excell cell's width and height and other cells in the same sheet is not
affected. Please see the EE-1.xls example excel files. How to do such Excel inregular cell format by VBA coding
2- What I know at this part for format cells is only as follows code
Range("C1").Select
Selection.ColumnWidth = 30
Selection.RowHeight = 50
Sheet2.Columns(1).ColumnWidth = 100
Sheet2.Range("A1:E1").Columns.AutoFit
Do you have any good tutorial and VBA manual to mention all control sheet and cell command and function syntax website
for recommandation
Please advise
Duncan
Attachment:EE-1.xls
