Autofit some columns

  • Thread starter Thread starter Me
  • Start date Start date
M

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
 
I found something:

xlsSheet.Columns("A:Z").AutoFit

A..Z is enough for me :)

Guy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofit 1
Autofit columns, password protected 3
Rows().AutoFit starts a calculation, but Columns().AutoFit doesn't 1
Excel column autofit 3
How to autofit variable columns? 2
AutoFit function 2
2007 AutoFit, WrapText, fails 1
AutoFit Infinite Loop? 4

Back
Top