Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi.
I am trying to resize my columns in Excel through VB6. I have created my excel.appliation object (xl) and created a new workbook. Now I want to use the code: xl.Cells(1, 1).Width = 100, but I get: Unable to set the width property of the Range class. Even when I try xl.Columns(2).Width = 100 I get the same error. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vb code to hide columns | Excel Discussion (Misc queries) | |||
Help with VB code to compare two columns | Excel Programming | |||
Code not hiding columns | Excel Programming | |||
sizing columns in code | Excel Programming | |||
CODE TO ADD TWO COLUMNS BASED ON ANOTHER | Excel Programming |