如何在VBA中设置一个合适的位置 [英] How to set the weitght for a coulmn in VBA

问题描述

VBA(Excel)中的Iam编程.但我可以为表格Excel的某些列设置权重
以及如何使用代码VBA在Excel中设置边框时如何知道所有线型(我只知道:xlcontinuos，xlDash，xlDashDot，xlDashDotDot)

如果知道，请帮助我！

非常感谢您

Iam programming in VBA(Excel). but I can set weight for some column of sheet Excel
and how to know all linestyle when set border in Excel using code VBA(I only know: xlcontinuos,xlDash,xlDashDot, xlDashDotDot)

if you know, please help me!

Thank you very much

推荐答案

线条样式枚举: http://social.msdn.microsoft.com /forums/en-US/vsto/thread/244ce468-135e-4504-9a77-ade5e0397938 [?您是说 Column.Width [ ^ ] ?

Line style enumeration: http://msdn.microsoft.com/en-us/library/office/bb241348%28v=office.12%29.aspx[^] and example: http://social.msdn.microsoft.com/forums/en-US/vsto/thread/244ce468-135e-4504-9a77-ade5e0397938[^]

What you mean "weight for some column"? Do you mean Column.Width[^]?

这篇关于如何在VBA中设置一个合适的位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！