Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VB and Excel
Message
From
06/03/2001 11:46:42
 
 
To
06/03/2001 11:34:59
General information
Forum:
Visual Basic
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00482262
Message ID:
00482274
Views:
11
>I have a VB app the opens up Excel and takes the values from a record set and places them into a spreadsheet. I want to change the widths of the cells and it is not working. I would like to have different widths for each of the cells, but I can set even change the width globally: oSheet.Cells.Width = 15000.
>
>Any suggestions would be appreciated.

Try with Autofit. Something like:

oSheet.Cells.Select
oSheet.Cells.EntireColumn.AutoFit
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform