Autofit worksheets in VB6

[chili pepperhead jeff]

Hello its me again

Can anyone out there point me to the way to autofit a range in w workbook (excel 2000) using VB6?

I know I can record a macro to do this

Thanks

Jeff

 

[igold]

What does the macro tell you when you recorded it...

 

[chili pepperhead jeff]

the macro works fine in excel - I'm copying and pasting data from some other worksheets and now before I close the WB I want to autofit all sheets (28) of them

I want to code that in VB6

 

[thes4s67]

the macro works fine in excel - I'm copying and pasting data from some other worksheets and now before I close the WB I want to autofit all sheets (28) of them

I want to code that in VB6

That macro is vb code :O

 

[chili pepperhead jeff]

But I just cant paste VBA code (which comes from the macro recorder) into VB6 procedure - BUT

I found the solution myself
Thanks for all the replies