Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference a Column by Number
Assuming if I did Insert=Name=Define, I would see a named range with the
name DateCreated_lbl, then Range("DateCreated_lbl").EntireColumn.ColumnWidth = 16 -- Regards, Tom Ogilvy "John Michl" wrote in message oups.com... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference a Column by Number
That works but is still only close <g
-- Regards, Tom Ogilvy "John Michl" wrote in message oups.com... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference a Column by Number
Thanks Tom. My version works but yours makes more sense!
- John Tom Ogilvy wrote: Assuming if I did Insert=Name=Define, I would see a named range with the name DateCreated_lbl, then Range("DateCreated_lbl").EntireColumn.ColumnWidth = 16 -- Regards, Tom Ogilvy "John Michl" wrote in message oups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate row/column number in reference formula | Excel Worksheet Functions | |||
Reference a number from a different column in a formula | Excel Worksheet Functions | |||
Selecting a range using a column number reference | Excel Programming | |||
chart label reference based on the column number | Charts and Charting in Excel | |||
reference to column (not known) and certain row number | Excel Programming |