| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofit some columns
Hi all.
I use VB6 to create an Excel file. I have a Recordset that might have different amount of fields (columns) - depends on a query. How do I fit all the columns with a loop ? TIA Guy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autofit some columns
I found something:
xlsSheet.Columns("A:Z").AutoFit A..Z is enough for me :) Guy "Me" лъб ... Hi all. I use VB6 to create an Excel file. I have a Recordset that might have different amount of fields (columns) - depends on a query. How do I fit all the columns with a loop ? TIA Guy |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autofit some columns
or
xlSheet.Columns.Autofit -- Regards, Tom Ogilvy "Me" wrote in message ... I found something: xlsSheet.Columns("A:Z").AutoFit A..Z is enough for me :) Guy "Me" лъб ... Hi all. I use VB6 to create an Excel file. I have a Recordset that might have different amount of fields (columns) - depends on a query. How do I fit all the columns with a loop ? TIA Guy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofit | Excel Discussion (Misc queries) | |||
| Autofit (Columns.EntireColumn.AutoFit) does not work | Excel Discussion (Misc queries) | |||
| Autofit Columns | Excel Discussion (Misc queries) | |||
| autofit columns in pivot table | Excel Discussion (Misc queries) | |||
| Columns.Autofit not doing what I want | Excel Programming | |||
Linear Mode
