Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- With objTable.Rows(the_row).Cells(the_col).Shape.TextFrame.TextRange.Font
- .Size = 12
- .Color = RGB(0, 0, 102)
- End With
- With objTable.Rows(the_row).Cells(the_col).Shape.TextFrame
- .VerticalAnchor = msoAnchorMiddle
- End With
- With objTable.Rows(the_row).Cells(the_col).Shape.TextFrame
- 'Internal margin:
- .MarginLeft = 'value goes here
- .MarginRight = 'value goes here
- .MarginTop = 'value goes here
- .MarginBottom= 'value goes here
- 'number Format:
- .TextRange.text = Format(1000, "#,##0.00") 'replace 1000 with your value
- end with
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement