You are correct. I didn't read the post properly.

--
Don Guillett
SalesAid Software

"JE McGimpsey" wrote in message
...
That won't affect ROWS...

In article ,
"Don Guillett" wrote:

manually
select the first columnhold shift keyselect last
columnformatcolumnwidth

in a macro

Sub setcolumnwidth()
Columns("a:j").ColumnWidth = 20
'or
'Range(Cells(1, 1), Cells(1, 10)).ColumnWidth = 20
End Sub