Help with setting column width within a script in Excel

Question

I'm getting errors when trying to set column widths within an excel script. I keep getting hit with "Property 'setColumnWidth' does not exist on type 'Range'."

What is correct to use? I'm not sure what I'm doing wrong here. I've seen that others have had similar issues, and copilot is telling me this should work as well.

    selectedSheet.getRange("C:E").setColumnWidth(10);

Answer 1

When I record a column width change script, I get code with getFormat(), like:

selectedSheet.getRange("C:E").getFormat().setColumnWidth(10);