Ask Question Forum:
C
O
M
P
U
T
E
R
2
8
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Y-position of the mouse cursor
Attachment:===
Excel specify cell format in VBA

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
SOrry, it is correct ee-2.xls , the previous is wrong and is ee-1.xls
Please download ee-2.xls again and review it , you will know my question
at question -3
Attachment:EE-2.xls
SOrry, it is correct ee-2.xls , the previous is wrong and is ee-1.xls
Please download ee-2.xls again and review it , you will know my question
at question -3
Attachment:EE-2.xls
SOrry, it is correct ee-2.xls , the previous is wrong and is ee-1.xls
Please download ee-2.xls again and review it , you will know my question
at question -3
Attachment:EE-2.xls