one for the office programmers out there

[mr_tony]

ok, starter for 10 :

Ok, got a component wot i wrote in vb6 that spits data into excel ina nice pretty format for our VP's to um and ahh over. However, I'd like to get the columns to 'autofit' and I can't find the method to call in the excel object reference.

Anyone know what it is? Pint to the first correct response as you'll save me staying here and missing out on one tonight....

[Plotloss]

Something along the lines of:

Worksheets("Sheet1" ).Columns("A:I" ).AutoFit

It should be a method of the Columns collection.

>> Edited by Plotloss on Friday 20th May 16:46

[pdV6]

Blimey. Quickdraw McPlotty to the rescue...

[Incorrigible]

Sorry you can't do it, that's as good as it'll get without me spending weeks on it

[mr_tony]

Plotloss said:

Something along the lines of: Worksheets("Sheet1" ).Columns("A:I" ).AutoFit It should be a method of the Columns collection. >> Edited by Plotloss on Friday 20th May 16:46

Ahhh autofit - thats what it's called - nice one plotty, one beer owed

msdev ref here



>> Edited by mr_tony on Friday 20th May 18:27