View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JS SL JS SL is offline
external usenet poster
 
Posts: 49
Default Set column width to fixed size if there's no data in it at all(except heading in row1)

Hello,

Simple question, but...€¦ what's the answer :)
Somebody knows it ? Thanks !

In a sheet there are many columns, but a few of them hasn't registered data in the rows. When using Cells.EntireColumn.AutoFit it's allways on a size that could be a bit smaller.

Therefore I like to run a macro that runs from first column to last used and check in each column if there is data (in row 2 till last used row). If not, then set the column width on 10.


Regards, Johan