Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

OLE : adaptive column width

shero_yy
Explorer
3 REPLIES 3
Read only

former_member186338
Active Contributor
935

Sorry, but do you understand that you question has no relation to the tag

EPM Add-In for Excel?

Just the word Excel?

Read only

MateuszAdamus
Active Contributor
0 Likes
935

Hello shero_yy

Have a look at this answer: https://answers.sap.com/answers/7482831/view.html

Kind regards,
Mateusz
Read only

Sandra_Rossi
Active Contributor
0 Likes
935

Why don't you run Excel, start the recording of macro and do the actions, that gives you the below code, that you simply translate to ABAP (see answer by Mateusz if you don't understand the relationship between VBA and ABAP OLE statements):

    Cells.Select
    Cells.EntireColumn.AutoFit