ExecuteExcel4Macro to set column width

[ttt123]

How can I use ExecuteExcel4Macro to set a column width? The reason I want to do this instead of through VBA is that ExecuteExcel4Macro seems to keep the Undo stack intack whereas VBA will clear the Undo stack.

I tried this but it didnt work: Application.ExecuteExcel4Macro ("COLUMN.WIDTH(50,""$A:$A"",FALSE,2,50)")

The API is defined in this PDF but it is not too clear how to correctly call it. Excel 4.0 Macro Functions Reference.pdf

 

[=ODIN=]

Try it using R1C1 style reference as text instead:

ExecuteExcel4Macro ("COLUMN.WIDTH(50,""C1:C1"")")

 

[ttt123]

Try it using R1C1 style reference as text instead:

ExecuteExcel4Macro ("COLUMN.WIDTH(50,""C1:C1"")")

thank you very much!

works great!