Resising Columns in vb code.
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.
|