Setting the Width of a column
Nirmal,
Because the property .Width is read only. The property .ColumnWidth can be
modified.
HTH,
Bernie
MS Excel MVP
"Nirmal Singh" wrote in
message ...
I need to set the width of a column. I am using the following code
ActiveSheet.Columns("A:A").Width = 57
This should set the width of the column to approximately 0.8 inches
(57/72).
I am getting the following error message:
Run-Time error '1004'
Unable to set the width property of the Range class.
Why not?
Nirmal
|