Cells(row,column) is for refering to a single cell

Columns(index) is for refering to a whole column

EntireColumn is a bridge between.

What is illogical about it?

Illogical is using a variable like liRowNum to refer to the column <g

Columns(liRowNum).font.Size = 12

should work fine for an entire column

Cells(1, liRowNum).Font.Size = 12

should work fine for a single cell.

--
Regards,
Tom Ogilvy

"Mike NG" wrote in message
...
Excel allows me to do something like
Columns(liColNum).ColumnWidth = cCellWidth

but after much googling I find out to change the font I need to use
something like
Cells(1, liRowNum).EntireColumn.Font.Size = 12

Why on earth is it designed like this.
--
Mike