Reference a Column by Number
False Alarm. I figured it out. I was close but not quite there...
Columns(Range("DateCreated_lbl").Column).ColumnWid th = 16
- John
John Michl wrote:
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
|