View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Camper Joe Camper Joe is offline
external usenet poster
 
Posts: 7
Default 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.