View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Michl John Michl is offline
external usenet poster
 
Posts: 81
Default Reference a Column by Number

I have a single cell named range called DateCreated_lbl. I'd like to
apply formatting to the entire column but can't seem to figure out the
proper syntax.

The following did not work:

Range(DateCreated_lbl).Column.ColumnWidth = 16

Columns.Range(DateCreated_lbl).ColumnWidth = 16

Is there a simple way?

Thanks

- John