Forum Discussion
Solved
Office script version of VBA for column autofit?
hi everyone, Do you know if there's a way to mimic the behaviour of the VBA command cells.entirecolumn.autofit using Office Script? I've managed to get this behaviour on a particular table (a...
- You can use something like:
selectedSheet.getRange("D8:J8").getFormat().autofitColumns();
See:
https://learn.microsoft.com/en-gb/office/dev/scripts/tutorials/excel-read-tutorial
Is the VBA code triggered by an event? e.g. worksheet_change? If so that won't work in Office Scripts as Office Scripts doesn't currently support events.
hi there,
No, with the VBA code it just applies to the worksheet under any circumstances - you type anything into the sheet and it will flex the column widths accordingly, live as you type.
I don't know VBA - is this sort of real-time behaviour governed by an 'event'?
No, with the VBA code it just applies to the worksheet under any circumstances - you type anything into the sheet and it will flex the column widths accordingly, live as you type.
I don't know VBA - is this sort of real-time behaviour governed by an 'event'?
- Could you share the VBA code? If so I would be able to confirm
- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.EntireColumn.AutoFit
End Sub