“Unable to set the Width property of the Range class”
<p>I'm working on automating the construction of a Cost Estimate sheet, sitting on top of the assumptions, rules, policies, etc</p>

<p>All going well until I want to automate setting column widths. Here a short distillation...</p>

<pre><code>Dim NumCE As Integer
Dim TotalWidth As Integer

NumCE = 1
Sheets("Cost Estimate").Range("A:A").ColumnWidth = 17  'THIS WORKS

TotalWidth = 17
Sheets("Cost Estimate").Range("B:B").Width = TotalWidth / NumCE 'THIS PROVOKES THE ERROR MESSAGE
Sheets("Cost Estimate").Range("B:B").Width = TotalWidth 'THIS PROVOKES THE ERROR MESSAGE - AS DOES THIS!
</code></pre>

<p>I'm working with Excel 2016 under the overall O365 bundle and within Windows 10 OS</p>

<p>Any ideas?</p>